Slicer For multiple columns

[Frenk_UM]

I'm new at PowerBI, mostly i can find my answers on google but i can't find this one.

I want to make a slicer that switches between columns (Years) (see example image), and express the total values in a graph.

So my slicer must have the options, 2022, 2023,2024,2025,2026

Thanks

[Arul · Accepted solution]

@Frenk_UM ,

Please follow the steps,

1. In power query editor, select all the year columns and do unpivot columns by doing right click,

you would get the result like this. 

2. Then if you do not want the blank rows in values you can filter it out from the dropdown,

Thanks,

Arul