Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I really need advice and would appreciate anyone who can help
on the left hand is a table consisting of three measures i created using counrows and calculate
e..g
Hi @Maz_0102
This is not working because measures can't give a filter context like columns.
This is also a reason that you can't use them as a slicer.
You should have the column Building Database [Technical Risk] in the visual that you want to use as a filter.
or maybe to use bookmarks with the functionality of switching between the visuals.
In your case, you can use 3 blank buttons up to the table which will switch between the same table filtered in different ways.
More information about switching between visuals with bookmarks here :
https://www.youtube.com/watch?v=cFZtUzABOa8
*again in your case the buttons will be blank without text / fill color.
and you will stay with the same visual just change the filter
I generated a small example you can see how it works here:
+
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |