Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.