Forum Discussion

daniellamoore29's avatar
daniellamoore29
Helper I
2 years ago
Solved

Gauge visual conditional formatting

Hi, I have a table with   1. 'target deadline' which is the overall financial year target i.e., 500 for the 4 quarters 2. 'Target' for each quarter i.e., 125 every quarter 3. 'Metric value' for e...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    daniellamoore29 Try this. PBIX is attached below signature.

    Measure = 
    VAR __Target = SUM('Table'[Target])
    VAR __Metric = SUM('Table'[Metric Value])
    VAR __Variance = SUM('Table'[Variance Threshold])
    VAR __Result =
        SWITCH( TRUE(),
            __Metric < __Variance, "Red",
            __Metric < __Target, "Yellow",
            "Green"
        )
RETURN
    __Result
daniellamoore29's avatar
daniellamoore29
Helper I
2 years ago

Greg_Deckler I've managed to add the Meaure to the conditional formatting as I amended the data types in the backend, thank you. 

 

I still have one issue, some quarters show the correct colour i.e., green colour or red colour, however some quarters still show blue. How do I amend these colours also?