Forum Discussion
ahsanlhcgov
9 years agoHelper III
Selection 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 shoul...
- 9 years ago
ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.
Regards.Pavel
- 9 years ago
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
PavelR
9 years agoSolution Specialist
ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.
Regards.
Pavel