cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sarav Frequent Visitor
Frequent Visitor

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 codes to be able to select and filter per code. 

 

Is that possible? 

 

Capture.PNGCapture2.PNG

 

Thanks, 

Sara

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to group fields

hi, @sarav

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:

1.JPG

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

2.JPG

3.JPG

then drag field Attribute and Values into slicer like this 

4.JPG

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

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

14 REPLIES 14
affan Established Member
Established Member

Re: How to group fields

Yes, this seems to be very mych possible.

 

Please share a sample of your data.

sarav Frequent Visitor
Frequent Visitor

Re: How to group fields

See my updated post Smiley Wink

affan Established Member
Established Member

Re: How to group fields

I am not sure how simple it would seem but you can just add a slicer visual and add the code field to it

sarav Frequent Visitor
Frequent Visitor

Re: How to group fields

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?

Community Support Team
Community Support Team

Re: How to group fields

hi, @sarav

You may try to a custom visual "HierarchySlicer" in MarketPlace.

5.JPG

Then darg field by parent-child structure like below:

6.JPG

 

 

Best Regards,

Lin

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sarav Frequent Visitor
Frequent Visitor

Re: How to group fields

Hi Lin,

That's a good idea but I need the heading of the field to show on the drop down list. The slicer only shows the values of the fields, whereas I need the header.

Any thoughts?
Thanks
Sara
Community Support Team
Community Support Team

Re: How to group fields

hi, @sarav

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

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
affan Established Member
Established Member

Re: How to group fields

Hi @sarav
Do you want to show or hide the whole column based on the filter selection or the values?
sarav Frequent Visitor
Frequent Visitor

Re: How to group fields

Hi Lin, 

 

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?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 497 members 3,921 guests
Please welcome our newest community members: