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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.