Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 84 | |
| 49 | |
| 38 | |
| 31 | |
| 30 |