Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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? ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Noo, I cannot 😞

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
2 years ago

If you don't mind me asking, what are the calculated columns? If you share the DAX maybe we can try to move them. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • audreygerred's avatar
    audreygerred
    Icon for Super User rankSuper User
    2 years ago

    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.