Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two slicers, Year and Quarter. The Year slicer has 'Current Year' and 'Last Year'. The quarter slicer has Year_Quarter. I want the quarter slicer to dynamically change based on the year selected. If Current Year is selected, then selected 'Current Quarter'. If Last Year is selected, then select, Previous quarter. NOTE: Two slicers are not related and should not be.
Here are the assumptions:
Your screenshot for Quarters is having force Single select option, so once you select anything it can change autoatically the other options, selection click will not get changed automatically.
However the requirement you mentioned above is possible, you can make changes to Quarter slicer so that it's not force selected. And then link year and Quarter slicers to each other and then edit interaction on visuals as you have mentioned above, if quarter should not impact Data1 then edit the interaction between these.
Hope above is making sense.
I went ahead and changed the Quarter filer so its no longer a single selected. Do you happen to have a DAX example to the 2nd part?
1). You can edit the interaction so that there are no interaction between Quarter slicer and Data1,2,3, same for Current Year/last year slicer. Edit interaction option you will get under 'Format' tab in toolbar pbi desktop.
OR
2). In the measures add "ALL" dax e.g Calculate (measure name/calculation, All(columnName)) This will ignore the selected column in slicer.
Hope above is making sense.
If possible you can share dummy pbix also.
Attached is the sample file. Thanks again for taking your time and looking into it.
https://www.icloud.com/iclouddrive/0TI9lHp56Cu64f9WIHUItrtMg#SampleYearQtr
Thanks for the file, unfortunately from the dummy file I am not able to identify what you are trying to achieve, I would suggest please share the pbix with dummy data but with your required visuals and structure.
If Previous Year is selected, the Year_Qtr_label should default to 'Previous Year Current Quarter.
If Current Year is selected, 'Current Quarter should be selected by default.
Note: The Quarter Data table should not have any impact on Current Year/Previous Year toggle. It should only toggle on Year_Qtr Label.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |