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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How to have two slicers so that one isn't affected by the other?

Hi all,

 

I've attached screenshots to show better what I'm asking. Basically, I have two slicers, both connected to the same dates. One shows the years, and one shows the quaters. If only one year is selected, it works how I'd like it to work.

 

08181bda-8f9b-46fe-af84-097741decf09.png

However, if I select more than one year, the quater slicer will now have 8 quaters for 2 two years, but I'd like it to only show 4 quaters at all times. Similarly, if I have one year selected, but only select 1 quater, the other years will dissapear from the year slicer.

 

Basically, I just want the slicers to always display the years, and 4 quaters. I don't want them to change depending on what is selected in the other slicer. Any help with this is appreciated

 

after 2.png

 

c4447ffb-5836-430d-ab00-940a6c3d829b.png

 

2 ACCEPTED SOLUTIONS
johncolley
Solution Sage
Solution Sage

Hi @Anonymous , You can use the edit iteractions feature to tell the slicers not to filter each other. Please see the link attached that details this process: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop 

 

If this answer solves your problem please mark it as a solution!

View solution in original post

Hi @Anonymous , are you using a separate date dimension table? If not I suggest you do. Some useful links below. Once created you should be able to use the Year and Quarter columns from these tables for your slicers. 

 

If you are still having trouble please post some sample data so that we have more information available to assist you.

 

https://radacad.com/do-you-need-a-date-dimension 

https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query 

View solution in original post

3 REPLIES 3
johncolley
Solution Sage
Solution Sage

Hi @Anonymous , You can use the edit iteractions feature to tell the slicers not to filter each other. Please see the link attached that details this process: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop 

 

If this answer solves your problem please mark it as a solution!

Anonymous
Not applicable

Okay great! That solved my first problem. Now it seems that the default for the quaters slider is to display all 12 quaters (for a 3 year time spam). Would you know how to make it so that it always displays 4 quaters? So, for example, if I had 2022 and 2023 selected, instead of the quaters slider showing all 8 quaters, it would only show 4, and if i selected Q1, the graph would then display Q1 from 2022 and 2023?

Hi @Anonymous , are you using a separate date dimension table? If not I suggest you do. Some useful links below. Once created you should be able to use the Year and Quarter columns from these tables for your slicers. 

 

If you are still having trouble please post some sample data so that we have more information available to assist you.

 

https://radacad.com/do-you-need-a-date-dimension 

https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors