Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to group fields

Hi there,    I have a dataset with Open End answers that have been codified the codes translate into fields in power BI, but I would like to have a drop-down list in the dashboard with all the code...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    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

     

     

     

affan's avatar
affan
Solution Sage
7 years ago
Hi Anonymous
Do you want to show or hide the whole column based on the filter selection or the values?
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?