Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional color formatting - overview

New to Power BI and it seems like there is no real way to do any dynamic color formatting based on a condition.

 

So if I just want to have my KPI be red if below a certain value and green if above a certain value that is not possible?  If not are ther any work arounds to formatting colors in Power BI based on certain conditions.

 

I really like Power BI for data gathering and modeling but it seems very flawed in its functionality for creating a good UI experience. I am a heavy Qlik user and it seems like there is so much more front end UI functionalityin Qlik - hopefully I am just new and not seeing all the features.

 

Z

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Using conditional formatting feature in Power BI Desktop, you can achieve your requirement. Please review the following screenshots.


    Regards,
    Lydia

  • parry2k's avatar
    parry2k
    8 years ago

    Standard KPI doesn't allow you to give the range, you have to probably look for custom KPI visual , here is link to KPI with lot of customization you can do with it.

13 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    So, the KPI visual has a Target Goals section in the Fields area. Often, you use an Enter Data query to just create your goals in a wide, single row table and just drag the appropriate column into the field. Or, just create a goal measure like:

     

    My Goal = 37

    And use that. You will need something in the Trend Axis field, use any column. If you really do not want any trend axis displayed, create a column like:

     

    My Column = 0

    And put that in your Trend Axis.

     

    Note that coditional formatting is available in Tables and Matrix visualizations as well. You can click on the little down arrow for a column or measure in the Fields area and choose "Conditional formatting" if it is a numeric field.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for the feedback!

       

      So it doesn't look like there is conditional formatting in KPI',s correct?

       

      Z

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        KPI by default shows green above a certain value and red below that value. Neutral is Yellow by default. You can change the default settings by using the Format area (paint roller icon) in the Visualizations pane under Color coding. You can change what is good and you can change your good, neutral and bad colors.

         

        If you are talking about the Gauge visual from the other post, then it has different options in the Format area. Under Gauge axis, you can just type in your Max and your Target. You can change the colors under Data colors, etc.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    I'm new on this forum and I hope I'm on the good topic.

     

    I really like Power BI and I would like to show to my team that we should move to Power BI for daily, weely and monthly KPI instead of excel. But we have strict standard for the visual interface for our KPI.

     

    Could you let me know if there is a feature in Power BI to respect the criterias below ? Standard graph or a safe custom one (something official)?

     

    Thank you!

     

    Our KPI shall:

    1. Data value (count) : Bars
    2. Objective : Straight line
    3. If value is lower than objective , the bars shall be red
    4. If value is higher than objective, the bars shall be green 
    5. Could be also the other way : lower than objective : green and higher than objective : red

    ex: