Forum Discussion

sasdfasdfsad's avatar
sasdfasdfsad
Advocate IV
11 months ago
Solved

Conditional Formatting for Data Bars color?

Using Data Bars on a matrix is very helpful, HOWEVER, it does not appear that there is a way to apply any conditional formatting to the color of the bar itself? https://learn.microsoft.com/en-us/pow...
  • Royel's avatar
    11 months ago

    HI sasdfasdfsad  you can achieve this by following this steps 

    Step 1: Create a Percentage Column 

    In here i have created this Profit% column 

    Profit% = 
    DIVIDE(
        [TotalProfit],
        CALCULATE(
            [TotalProfit],
            ALL(financials)  
        )
    )

     

    Step 2: Create a measure for conditional color 

    Performance Color = 
    SWITCH(TRUE(),
        [Profit%] >= 0.2, "Green",
        [Profit%] >= 0.15, "Yellow",
        [Profit%] < 0.12, "Red",
        "Gray"
    )

    This one is for your conditions 

    Performance Color = 
    SWITCH(TRUE(),
        [Your Percentage Field] >= 0.9, "Green",
        [Your Percentage Field] >= 0.7, "Yellow",
        [Your Percentage Field] < 0.7, "Red",
        "Gray"
    )

    Step 3: Create a visual and select your column for Conditional formating 

     

    Step 4: Set you measure here 

     

    Results: In my case i have update my conditions point to fit my data 

     

     

    Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!