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.
Hi,
As shown in below screen shot, I have create a measure called: Mutual Slice Filter and used it to filter Scenario Slicer based on Financial year slice. I have added the measure to Filter Pane in Filter on this visual section. However looks like my solution is not working properly as when I select financial year 2021-22, scenario "FOR" ( Forecast) is not appearing in Scenaro slicer though it exists in financial year 2021-22. To prove that it exists I created a table visual which list all scenarios in 2021-22. Am i missing something?
Thanks
Solved! Go to Solution.
It's hard to see without knowing how your model is set up, which tables are used for the slicers, what each field means....
If you want one slicer to filter another, and the fields used are in dimension tables, create a measure along the lines of:
Filter Slicers = COUNTROWS (RELATEDTABLE(Fact Table))
Add the measure to the filter pane for each slicer and set the value to greater or equals to 1.
If that isn't the problem, please share sample non-confidential data or a link to a PBIX file in a clud service and a depiction of the expected outcome.
Proud to be a Super User!
Paul on Linkedin.
It's hard to see without knowing how your model is set up, which tables are used for the slicers, what each field means....
If you want one slicer to filter another, and the fields used are in dimension tables, create a measure along the lines of:
Filter Slicers = COUNTROWS (RELATEDTABLE(Fact Table))
Add the measure to the filter pane for each slicer and set the value to greater or equals to 1.
If that isn't the problem, please share sample non-confidential data or a link to a PBIX file in a clud service and a depiction of the expected outcome.
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |