Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is it possible to have a slicer to only show rows where at least one column shows the selected data?
Example:
I have a table with two columns CreatedID and ClosedID.
I want to be able to check off an ID in a slicer then have my visuals only show data where that ID exists in either column.
Solved! Go to Solution.
How about unpivoting the 2 columns using Query Editor.
Then you can create a slicer from that single unpivoted column which contains both Created and Closed IDs
How about unpivoting the 2 columns using Query Editor.
Then you can create a slicer from that single unpivoted column which contains both Created and Closed IDs
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |