How can we improve Power BI?

conditional formatting intervals

It would be very useful to be able to tailor conditional formatting by applying users own definitions for intervals.

Example being:
1-3,Red
4-6,Yellow
7-9,Green
or
1-25%, #5956C3
26-50%, #C356C1
51-75%, #5C9B9C
76-100%, #73C374

94 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Tera commented  ·   ·  Flag as inappropriate

    Max,

    I have tried conditional formatting on percentages in a column, and this feature is not working. Have you used it successfully on a percentage? And if so, please share how. My values range from .34% to 32.32% and each time I try to add conditional formatting I only get 1 color - no variance.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I would like to see heat mapping available, highest to lowest, hottest to coldest.

  • Matthew Smith commented  ·   ·  Flag as inappropriate

    This is probably the most important conditional formatting update. Maybe expand to be able to use a formula such as >= 90% green ;. <90 >70 yellow; <=70 red

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.