Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
We have an aggregate view as a datas source, which is in this format -
This view is used to generate a report in this format in a matrix with Values into row groups -
Is there a way we can get Variance value in percentage value of plan? Something like this -
Appreciate your assistance.
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?
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.
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |