Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
11 months ago
Solved

Conditional Formatting not working in Matrix Visual

Hi,   I have duplicated a Matrix visual so that a COUNT and % are displayed in each visual (I selected the option 'show values as % of Row Total')   The values are just based on this simple...
Need Help
Show and Tell
  • ArchStanton's avatar
    ArchStanton
    11 months ago

    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:

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
11 months ago

Hi,

Share the download link of the PBI file.

ArchStanton's avatar
ArchStanton
Power Participant
11 months ago

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: