Forum Discussion

Frenk_UM's avatar
Frenk_UM
New Member
3 years ago
Solved

Slicer For multiple columns

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 ...
Show and Tell
  • Arul's avatar
    Arul
    3 years ago

    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

Arul's avatar
Arul
Super User
3 years ago

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