How do I use a slicer to display data from 3 different columns?

[Anonymous]

Am new so let me know if this is possible

Name	age	gender	country	eyes
person a	1	f	finland	blue
person b	2	m	finland	white
person c	2	f	australia	red

how do I make the slicer, so the it gives me columns as options. So i can pick age, gender, country, eyes, name.

My end goal

so when i click on country in the slicer the donut chart will show that there are 2 people from finland and 1 from australia.

[v-chenwuz-msft]

Hi @Anonymous ,

The method mentioned by other , unpivot table, is quite correct. I will provide a method which may be tedious to operate, you may refer to it. It mainly uses bookmark and selection.

By creating a bookmark, the columns you don't need are hidden. The bookmark is then linked via a button to achieve the slicer effect.

My pbix file attached in the end you can refernec.

Best Regards

Community Support Team _ chenwu zhu

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

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I think one of the good ways to solve this is to unpivot the table like the sample pbix file attached down below.

[YukiK]

I think you're looking to do something like this: https://community.powerbi.com/t5/Desktop/Dynamically-add-or-remove-columns-from-table-visual-using-s...

It'll make a slicer by unpivoting your table.

One workaround I thought of is to have as many bookmarks as the number of columns. And you create a table for each case and you'd toggle visual by the bookmarks you create.

Hope that helps!