How to display the month wise values based on year...

FabCon is coming to Atlanta

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Fabric Community

- Submit ideas & vote
- Fabric roadmap
- Community support
- Product support

Register
·
Sign in
·
Help

Go To

Power BI forums
Get Help with Power BI
Desktop
Service
Report Server
Power Query
Mobile Apps
Developer
DAX Commands and Tips
Custom Visuals Development Discussion
Health and Life Sciences
Power BI Spanish forums
Translated Spanish Desktop
Training and Consulting
Instructor Led Training
Dashboard in a Day for Women, by Women
Galleries
Data Stories Gallery
Themes Gallery
Contests Gallery
Quick Measures Gallery
Notebook Gallery
Translytical Task Flow Gallery
TMDL Gallery
R Script Showcase
Webinars and Video Gallery
Ideas
Custom Visuals Ideas (read-only)
Issues
Issues
Events
Upcoming Events

cancel

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Search instead for

Did you mean:

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Power BI forums
Get Help with Power BI
Custom Visuals Development Discussion
How to display the month wise values based on year...

Topic Options

Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Printer Friendly Page

All forum topics
Previous Topic
Next Topic

Anonymous

Not applicable

Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Email to a Friend
Report Inappropriate Content

How to display the month wise values based on year selection in Line Chart

‎08-09-2020 10:05 PM

Hi Hello, We have requirement like below.

I have month wise data as shown below screenshot. i want to disply sum of values like if current month is lessthan previous month then need to display previous month else current month.

For Example, for May month we have sum is 15 which is lessthan previous month (April 25). i need to display values of May is same as April values. same for all month based on Year slicer selection in power bi.

Please help me on this.

Source Input:-