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.
Create a formula to highlight 10% above and 10% below Group % or if there is a better way to do it, possibly conditional formatting, i dont know?
----------------------------------------------------------------
Below is my matrix. Hoping someone could help me to figure out a formula that highlights the Provider % when it is 10% above or below the "Group %" ...
Here are some of the Fields and measures that I am using in my matrix
1. (Field) Provider Name
2. (Field) CPT
3. Visits "Count Distinct"
4. Provider % aka "CPT Code" shown as "Count" with value shown as Percent of row total.
5. (This is a calculated Measure) Group % aka "Group Average Ignore Degree". For the first part of this measure you will need "Group Average" which is:
Hopefully the information I gave you is enough. I cannt attach sample data, but if you send me your email I will send you over a sample report that someone sent me form the Power BI community where they got it to work.
I can send you this file if you drop me your email!
I think the reason I cannot get to work on my end is because on the sample data for the "Group%" Field they are using a Field that has the funny looking "E" in front of it. Where my Group % is a calculated Measure.
Solved! Go to Solution.
@jonnyA You can bring your flag into your matrix as well to make sure it's calculating correctly. I have attached a PBIX where you can see it applied.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi @jonnyA ,
In addition, if you want to hide the flag measure in the matrix visual, try this:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jonnyA You can create another measure that flags if it is 10% +/- of the Group, like so:
10 Percent Flag = IF ( [Provider %] >= [Group %] + 0.1 || [Provider %] <= [Group %] - 0.1, 1, blank())
Hope this helps!
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
I also tried your suggestion in conditional formatting ...
But that Conditional Formatting Highlighted every row (See screenshot below)
Do you have any Conditional Formatting suggestions?
@jonnyA You can bring your flag into your matrix as well to make sure it's calculating correctly. I have attached a PBIX where you can see it applied.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi @jonnyA ,
In addition, if you want to hide the flag measure in the matrix visual, try this:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @Icey! That is a good way to hide them, and they can also be removed from the matrix once you have determined they are calculating correctly too.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Thank you for the time you put in for your response.
I might be doing something incorrectly.
I created the formula you said to create.
Maybe you can help me with Conditional Formatting.
This is what I tried, but was not successful in my matrix being color coded.
User | Count |
---|---|
119 | |
65 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |