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/power-bi/create-reports/desktop-conditional-table-formatting#add-data-bars

 

Is there anyway to use conditional formating like how the background color can change?

I would like my bars to be green >=90%
yellow >=70% <=89%
red if <70%

I don't see anyway to accomplish that.

  • 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!

     

5 Replies

  • Hi sasdfasdfsad 

     

    You can perform some conditional formatting:

     

    My advice, would be to create a dax measure to achieve that

    If you have some dummy data, do not hesistate to share them with us, we could create the dax measure for you 😉

  • 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!

     

  • v-priyankata's avatar
    v-priyankata
    Community Support

    Hi sasdfasdfsad 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    Cookistador Royel Thanks for the inputs.

    I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

     

    • v-priyankata's avatar
      v-priyankata
      Community Support

      Hi sasdfasdfsad 

      I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.

      • v-priyankata's avatar
        v-priyankata
        Community Support

        Hi sasdfasdfsad 

        Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.