Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi,
I might need to change the structure of my dataset but before I do, I'd like to know if I can create a custom slicer based on multiple columns. Here is how my dataset is currently structured and what I'd like the slicer to do.
I'd like the slicer to separate each 3 columns into one option as displayed above. Is there a way to do so or I should restructure my dataset instead and have a new column called category that would distinguish what column is bag or bank for example.
Thank you.
Solved! Go to Solution.
@Whoule ,
I think restructuring would be the best option based on your requirement of bring those column values in slicer.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 53 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 122 | |
| 108 | |
| 44 | |
| 32 | |
| 26 |