How can we improve Power BI?

Conditional formatting (cell highligh, font, etc) when comparing multiple fields

PowerBI needs to have the ability to offer conditional formatting of based on the comparison of 2 or more metrics. For example if metric A = metric B then change the font and highlight color of the cell to red.
If metric A > metric B and metric A < metric C then change the font and highlight color of the cell to green.
This should be unlimited for how many colors can be used. Other BI tools offer this feature.
Note that this is different than what PowerBI currently calls ‘conditional formatting’

1,429 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    34 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Vincent commented  ·   ·  Flag as inappropriate

        You can start with a somewhat primitive workaround like SSRS uses: Allow report level code and report field background/foreground propery to allow user enttry expression that references this code and returns proper colour depending on what report level code returns, i.e. analyze how it works in SSRS and implement.
        Omitting proper conditional formatting based on other columns of various data types is probably a deal breaker for my company as we are migrating to Power BI existing reports in SAP BO that has extensive formatting possibilities. I rebuild some of them in SSRS and got it to work, but if I have to rebuild them in Power BI and users lose all conditional formatting because 90% of conditional formatting in my existing reports is not surported in Power BI.
        Please make this functionality a priority. The November 2017 update was an improvement but unfortunately not enough to make it usable in my case.

      • Anonymous commented  ·   ·  Flag as inappropriate

        8 months, 1,233 votes later and still no reply.
        Are we ever getting this or should we give up?

      • Toon Coulier commented  ·   ·  Flag as inappropriate

        what's up Doc. ;-) ? 14 pompondertjes is exalle to 15 kiloWhatt's ? ° blub plonsh the sun reflected on water .....

      • John Ashley commented  ·   ·  Flag as inappropriate

        I'm quite happy to do the comparison in a different column (probably hidden) and format based on that value. What ever is simplest to get this EXTREMELY valuable feature started, especially since the Nov 2017 update.

      • Iain commented  ·   ·  Flag as inappropriate

        I cannot understand why such a basic function in excel is not in power BI. This would be so useful

      • Melissa.Wegner commented  ·   ·  Flag as inappropriate

        we need the ability to conditional format by column based on different values related to that column... So I want column A to have color formatting based on different criteria than column B. Currently i am only aware you can do conditional formatting on one column

      • Anonymous commented  ·   ·  Flag as inappropriate

        Need to also be able to conditionally format based on a field that is not a measure. You should be able to conditionally format based on any field type; Text, Date, Number, Etc - this is reporting 101

      • Jani Liimatta commented  ·   ·  Flag as inappropriate

        We need expressions everywhere, not only formatting. I run daily into the limitations PowerBI has.

      • Elena Schott commented  ·   ·  Flag as inappropriate

        If we can get conditional formatting based on other cells in the row available, then folks can add baby images as a cell type separately (arrow, circle, stoplight, baby chickens, whatnot) and be able to colorize them etc based on this which is needed first.

      • Wade commented  ·   ·  Flag as inappropriate

        Yes, exactly, what would also be good to be able to use your own image url's in the matrix tables as values, or if the image url's could be integrated into conditional formatting interface. For a service health dashboard, you really need a matrix table with the values as the service health icons. E.G. Rows would be the name and columns would be the date, then values would be an icon set representing an outage or green checkmark, etc....

      • Kees Kuip commented  ·   ·  Flag as inappropriate

        I abandoned power bi in favour of excel with powerquery and powerpivot.
        This formatting is available in excel but not in power bi!

      • Said commented  ·   ·  Flag as inappropriate

        We need a feature that allows us to visualize some data with icons like traffic lights, flags, and arrows as in Excel. Sorry for my english but I understand a little

      ← Previous 1

      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.