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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anno2019
Helper IV
Helper IV

How to show all "months" that ignore date slicer

Dear Guru's

 

There are a ton of posts that touch on this subject but I cannot find one that relates to my particular issue.

 

I have graph which should like the image below.  The problem is that I have a Date Slicer which I would like this graph to ignore completely.  I managed to get the Measure correctly calculating the number of invoices ignoring the date slicer but I don't know how to get the "YEAR MONTH" Axis dimension to ignore the slicer aswell.

Any ideas??

 

Show all months in Graph.ignore Slicer.JPG

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

You Can use all in you measure

calculate(sum(Table[value]),all(Date)) // Assume Month year is from date table

Or Switch of interactions

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Interactions.png

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

You Can use all in you measure

calculate(sum(Table[value]),all(Date)) // Assume Month year is from date table

Or Switch of interactions

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Interactions.png

@amitchandak  thank you.  Worked perfectly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.