Forum Discussion
Filter using a single Slicer for multiple columns
Can we add a Slicer (dropdown list) to filter visualizaion result based on 2 or more differnet coloumns?
The source sheet is like below screenshot. Each call could be done for 1, 2, or 3 different products. We need to use one slicer to filter the calls that have been done for a specific product whether it's in Prodcut, Product2, or Product3 column.
Any idea?
4 Replies
OmarSaleh It would be recommended to unpivot your product columns. If for some reason you cannot do that, then you could create a Complex Selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Hey OmarSaleh ,
absolutely, you can add multiple columns to a slicer. Then the slicer is building a hierarchy.
Check the documentation on how to do that:
Add multiple fields to a hierarchy slicer - Power BI | Microsoft Docs
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHI OmarSaleh,
I agree with Greg's suggestion, you can do unpivot on your product fields to convert them to attributes and values. Then you can use value as source of the slicer to filter all the product fields.
Unpivot columns (Power Query) (microsoft.com)
Regards,
Xiaoxin Sheng
Hi OmarSaleh,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
