Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ovonel
Post Prodigy
Post Prodigy

how to pivot measures in a visual?

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

 

ovonel_0-1670593233457.png

 

 

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

ovonel_1-1670593233461.png

 

 

 

 

Then I create a measure, to use the measures:

 

ovonel_2-1670593233463.png

 

 

 

 

 

Then I just drag them in my Table visual:

ovonel_3-1670593233465.png

 

 

 

 

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

 

 

 

 

 

 

3 REPLIES 3
ovonel
Post Prodigy
Post Prodigy

@lbendlin 

 

amazing thanks, works like a charm...

 

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

ovonel_0-1670836575562.png

 

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

lbendlin
Super User
Super User

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.