The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
86 | |
84 | |
36 | |
34 | |
34 |
User | Count |
---|---|
94 | |
79 | |
65 | |
55 | |
52 |