Forum Discussion
How to group fields
- 7 years ago
hi, Anonymous
After my research, I'm afraid it couldn't achieve that have a slicer with three columns as you want on your original data structure in Power BI for now. You may try to use three slicers like this:
Also, if you want them in one slicer, you may try to use this way:
In Edit Queries, select accessibility, booking, experience then click Transform-> Unpivot columns
then drag field Attribute and Values into slicer like this
By the way, This method will turn your this data table three times as large.
and here is demo pbix, please try it.
Best Regards,
Lin
Yes, this seems to be very mych possible.
Please share a sample of your data.
See my updated post ;)
- affan7 years agoSolution Sage
I am not sure how simple it would seem but you can just add a slicer visual and add the code field to it
- Anonymous7 years agoNot applicable
A slicer visual is only showing the option of data for each of the fields (positive / negative / neutral). However, what I need is a slicer visual that has the codes: accessibility, booking, experience.
Do you have any ideas on how that could work? Would the option of transposing the table work?
- v-lili6-msft7 years agoCommunity Support
hi, Anonymous
You may try to a custom visual "HierarchySlicer" in MarketPlace.
Then darg field by parent-child structure like below:
Best Regards,
Lin