Forum Discussion
Solved
Slicer to filter based on several columns
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.
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
1 Reply
- Zubair_Muhammad
Community Champion
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