Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I've got this matrix, with the fields Date, Category (each row in the matrix is a category) and Sold%.
Sold% is a measure:
Percentage =
VAR numerator = COUNTROWS(
FILTER(
ImportedData,
ImportedData[Products] <> "sold")
)
RETURN DIVIDE (numerator, ImportedData[TotalProducts])
The issue is the formatting on the matrix doesn't work how I expect it to. I've got these thresholds for the matrix's conditional formatting to indicate the percentage of products sold.
For some reason, the matrix appears like this (91% shouldn't be that shade of green for example)
Just to check, I changed the top threshold to blue to see what happens
And 91 becomes blue:
Any ideas what could have gone wrong? Any help is appreciated.
Solved! Go to Solution.
@Anonymous , Change all percent to the number and use number like .8 for 80%
Thank you, it worked! Very strange how the matrix is like that.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
37 | |
31 | |
26 |
User | Count |
---|---|
96 | |
84 | |
43 | |
40 | |
35 |