how to pivot measures in a visual?

[Anonymous]

I need to “recreate” a report from another system, and I have to do visuals like:

This cannot be natively achieved in PowerBI… Therefore I end up doing this “”trick” in my model:

Then I create a measure, to use the measures:

Then I just drag them in my Table visual:

Is there any other way to achieve this? Or is my solution the only possible way?

[Anonymous]

@lbendlin 

amazing thanks, works like a charm...

But, now what if I have to do many columns, like:

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[lbendlin]

No need for any tricks .  Learn about arranging matrix values as "Show on rows"