Forum Discussion
Unpivot table visual
Hey guys! I wanted to know, is there a way to pivot a table visual? I have a table that looks like this: Is there a way to change it IN the visual in order to get something like this? ...
Im sorry, the idea here is to pivot ALL of them. The ones that come in the excel file + the ones I calculated.
Unpivoting only the ones in the file does not resolve my issue.
The columns that you are adding in as calculated columns, can you add them in in Power Query instead of adding them in as calculated columns in DAX?
Noo, I cannot 😞
If you don't mind me asking, what are the calculated columns? If you share the DAX maybe we can try to move them.
I cannot share the file given it has sensible data.
And the calculated columns are calculations that give a description "Poor" "Nice" "Great" "Excellent" depending a large set of conditions