Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
scottiamit
Frequent Visitor

Ignore Filters and always show last 12 months in graph month by month

Hi all, I have some CRM communications I want to show the number added month by month for 12 months. This graph needs to ignore any filters (specifically date filters) from the page or any other pages as there is often a month or fiscal year filter set. In the image below on the left you can see the communications added month by month for the current fiscal year which we are 3 months into hence only 3 months showing. I created a DAX to calculate the total number entered for the last 12 months which calculates correctly in the right graph as 1094 however when I add the month month name/year column in from the calendar table the value is the same total for all 12 months. How do I get this to show the correct value for each of the 12 months? I realise I could do a DAX for each previous month however this could be 12 measures and will get messy as I also need to do the same thing for many other areas such as quotes, sales orders, accounts addded etc etc so would end up with way to many measures.

 

Thanks heaps, this has been driving me nuts!

 

scottiamit_0-1694039330044.png

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

I have solved a similar problem in the attached PBI file.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
scottiamit
Frequent Visitor

Awesome! Thanks very much for the reply I will check it out shortly.

Ashish_Mathur
Super User
Super User

Hi,

I have solved a similar problem in the attached PBI file.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.