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? ...
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
It's likely that those columns can be created in Power Query instead of DAX. You can create conditional columns in Power Query and use the Advanced editor to write the code if needed.