Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Column names function as slicers for visuals?

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.

 

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    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.

     

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    3 years ago

    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.