Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Team,
I have a requirement where i have a view with all dimentions and transactions together.
Have 6 slicers in a page Slicer1, Slicer2, Slicer3.... Slicer6
Now I want 2 measures to be created
Measure1 = Count rows based on only slicer1 or slicer 2 selection and ignore if I select anyting in slicer 3, 4, 5 and 6.
Measure2 = Count rows based on only slicer 3, 4, 5 and/or 6 and ignore if I select anyting in slicer 1 and slicer 2
I want to show both measures side by side in a table visual.
All this data is in single view. I tried using ALL, ALLSELECTED, ALLEXCEPT. Nothing is working. Can someone please help me with the same?
Thanks!
if all your 6 slicers and sales tables are the same table, then you won't get anything.
you need to create separate dimensions for each slicer , and only then can you use REMOVEFILTERS, ALL
Yes @Ahmedx. You are 100% right.
But the problem is, if I seperate the dimensions (1 table for each dim slicer), slicers are not connected to each other.
I want slicers also to be interacted so that if I select a value in slicer 3, only the corresponding values should show in slicer 4.
@Ahmedx @Greg_Deckler @lbendlin @DOLEARY85 - Any help here is much appriciated. Thanks!
use REMOVEFILTERS
You mentioned dimensions so I (wrongly) assumed you had a data model. Please normalize your data as needed.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
108 | |
98 | |
39 | |
34 |
User | Count |
---|---|
151 | |
122 | |
76 | |
74 | |
50 |