Forum Discussion
Helper IIISelection list for column names.
Hi. Can someone please help me with this one.
I have a table for all the expensenes monthly sliced. I need to have 1 column and have all the months as a selection so which ever I select it should show that months figures.
Please can someone look and advise if that is possible
ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.
Regards.Pavel
You need to unpivot your data during the get data process.
Here is an old video I created. The principle and approach is the same in Power bi
2 Replies
PavelRSolution Specialist
ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.
Regards.Pavel
- MattAllington
Community Champion
You need to unpivot your data during the get data process.
Here is an old video I created. The principle and approach is the same in Power bi