Forum Discussion
How to group fields
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
hi, Anonymous
The slicer only shows the values of the fields, whereas I need the header.
Do want to just select the header that like select "year" then show all year, but in power bi, when you don't select any value in slicer, it will like select all, show all values. It doesn't make sense.
If I get it wrong, Can you explain to me according to the sample data and expected output?
Best Regards,
Lin
Do you want to show or hide the whole column based on the filter selection or the values?
Hi Affan,
If you look at the fields these are:
- accessibility
- booking
- experience
I want to show these in the dashboard, so people can select whether to see comment for each of the topics. So, I'd like to have a slicer with the following:
- accessibility
- Positive
- Negative
- booking
- Positive
- Negative
- experience
- Positive
- Negative
Does that make sense?