cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How to get date slicers override visual specific filters

Hi,

 

Is it possible to have a visulization defaulting to a time range but still respond to other time ranges selected through slicers?

For example, I want to have pie chart that shows commission earned during "last month" by line of business. However I want to have a separate slicer in the same page that shows fiscal years/ quarters/months as the case may be. I am looking for functinality where in by clicking  last fiscal year, the pie chart should show data for last year instead of  its default "last month"

 

I am a new user and still learning. Thanks in advance for any help!

 

 

2 REPLIES 2
Highlighted
Super User IX
Super User IX

Re: How to get date slicers override visual specific filters

Take a look at ISFILTERED and ISCROSSFILTERED functions.

 

https://msdn.microsoft.com/en-us/library/gg492197.aspx


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
New Member

Re: How to get date slicers override visual specific filters

Thank you very much! I shall try this. 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors