Forum Discussion
Conditional Formatting not working in Matrix Visual
A big thanks to everyone who has offered me help with this - thanks to your input I managed to find a way of solving my issue using the following DAX:
Percent of Row = DIVIDE( COUNT('Cases'[applicationvalidationdate]), CALCULATE( COUNT('Cases'[applicationvalidationdate]), REMOVEFILTERS('Cases'[Days to Validation Bins]) ) )
I then applied the following Conditiional Formatting criteria to the percentages (using numbers as advised).Which gives me the desrired result in my Matrix visual:
Hi, thanks for your reply.
I can't get this to work. I have a calculated column which counts the number of cases that are in the following bins:
0-1 Mth
1-2 Mths
2-3 Mths
Older
This Calculated Column is located in my main Fact table 'Cases'[Days to Validation Bins]
I have created a % Measure for 0-1 Mth only=
1 Mth % =
VAR UnderOneMth = [0-1 Mth Count]
VAR AllBinAges = [ALL Count]
RETURN
DIVIDE(UnderOneMth,AllBinAges)
0-1 Mth Count Measure =
0-1 Mth Count =
CALCULATE(
[AppValCount],
KEEPFILTERS(
'Cases'[Days to Validation Bins] = "0-1 Mth"))
All Count Measure
All Count =
CALCULATE(
[AppValCount])
I'm not really sure what to do with this, I've replied to another expert so maybe what I have said there may help?
Hi,
Share the download link of the PBI file.
Not possible due to data privacy I'm afraid
Create a copy of that report with confidential data anonymized or removed. We don't need the actual pbix.
I have fixed the issue now so I don't need any more help - I have explained how in the replies.
FYI: my report is connected to a live Dynamics database so this isn't possible.
A big thanks to everyone who has offered me help with this - thanks to your input I managed to find a way of solving my issue using the following DAX:
Percent of Row = DIVIDE( COUNT('Cases'[applicationvalidationdate]), CALCULATE( COUNT('Cases'[applicationvalidationdate]), REMOVEFILTERS('Cases'[Days to Validation Bins]) ) )
I then applied the following Conditiional Formatting criteria to the percentages (using numbers as advised).Which gives me the desrired result in my Matrix visual:
