Slicer For multiple columns

Question

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 Answer

Frenk_UM&nbsp;,
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.&nbsp;
2. Then if you do not want the blank rows in values you can filter it out from the dropdown,

Thanks,
Arul

Forum Discussion