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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
nbitabc
Helper I
Helper I

Different number format in the same row for a metric

We have an aggregate view as a datas source, which is in this format -

nbitabc_1-1712155132656.png

This view is used to generate a report in this format in a matrix with Values into row groups -

nbitabc_2-1712155192558.png

Is there a way we can get Variance value in percentage value of plan? Something like this -

nbitabc_3-1712156608012.png

 

Appreciate your assistance.

 

 

3 REPLIES 3
nbitabc
Helper I
Helper I

Thanks @Gabry. Issue is that Variance is not a separate measure. It is actually an entry in the Key Figure Type column (check the source data screenshot). We can create a new measure for Variance but then we won't be able to maintain the report format as we need Variance as a column header in the matrix

Understood, can't you create a measure that checks if the variance is inscope?

Gabry
Super User
Super User

Sure, here's an improved version:

Yes, you can achieve that. I believe you can accomplish it using the format panel of the matrix. You should be able to select specific column formatting and then choose 'variance.' If that doesn't work, you can create a measure that checks if the variance is in scope. If it is, the measure returns 1. Then, you can set up a conditional formatting rule based on this measure. If the measure equals 1, apply the red color.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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