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:

     

ArchStanton's avatar
ArchStanton
Power Participant
11 months ago

Not possible due to data privacy I'm afraid

danextian's avatar
danextian
Super User
11 months ago

Create a copy of that report with confidential data anonymized or removed. We don't need the actual pbix.

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    11 months ago

    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.