Column names function as slicers for visuals?

[Anonymous]

Hi,

If I have a dataset like this, and the "Tabs" are colum names:

Then how can I make it so these column headers (Tab1 - Tab8) are slicers that change the diagram accoording to my selection?

So for example, if there are multiple years (2008-2020) for each rows, and there are Yes and No values for each tabs (or some other values as well), how can I make it so these column names function as slicers?

Thank you for your help.

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

You can try the following steps in the power query, and then you can use the column header as a slicer

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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