Forum Discussion
CarlsBerg999
Helper V
Helper VSlicer in columns
Hi, I have an issue with Power Pivot and my current data. The idea is identical as with Power BI, so i posted it here. I have three columns: Sales 2019, Sales 2020 and Sales 2021. I want to sum t...
CarlsBerg999 , Not very clear.
You can unpivot the data. And separate out year
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/Also, you can use more than one column in pie. Do not give legend in that case.
amitchandak
Super User
Super UserCarlsBerg999 , Not very clear.
You can unpivot the data. And separate out year
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Also, you can use more than one column in pie. Do not give legend in that case.