The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance 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.
User | Count |
---|---|
80 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
107 | |
97 | |
55 | |
47 | |
46 |