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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
SRJPBI
Frequent Visitor

What is the best way to display multiple measures in rows & columns?

Hi all,

 

In my report I have some measures which calculate various KPIs. These are currently displayed in a multi row card: 

 

SRJPBI_1-1695208656396.png

 

Some, but not all, of these KPIs have a additional measure calculating their growth vs a forecast. I'd like to display these next to the existing measures. However, if I set up a corresponding multi row card then the measures are misaligned. E.g. KPI_3_growth is not next to KPI_3:
 
SRJPBI_2-1695208760423.png

 

To be clear, each value marked 'KPI_' is the result of a separate measure. 

 

I could display each measure in a separate card and arrange the cards as I wish, but I feel there has to be a more elegant solution. I've tried using a single table visual, but I could only get it to display all of the measures on a single row:

 

Does anyone know the best way to achieve the desired result please? 

 

If it helps, I also don't mind if the result is transposed, e.g. 'Selected period' and 'growth vs forecast' as row headers instead of column headers.

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @SRJPBI ,

 

You can use the new card visual that takes many values and display each of them seperately 

Idrissshatila_0-1695210108094.png

 

or you can put them in a table.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thanks for the response. What version of PBI has this visual please? I am using 2.94.921.0 and can't see it. 

 

If I put the measures in a table as values, they all just appear on one row:

 

SRJPBI_0-1695211253657.png

 

Do you know how I can configure the table so they appear on separate rows with the KPIs lining up with their growth (e.g. KPI_3_growth in the same column as KPI_3 etc)?  

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors