How can we improve Power BI?

More flexible Conditional Formatting in Tables and Matrixes

More flexible Conditional Formatting in Tables and matrixes.
The current color customization in tables is very limiting. I need more than 3 color choices.
I should be able to add multiple values and assign colors to each.

316 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

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

    18 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...
      • Joe KatuzienskiJoe Katuzienski commented  ·   ·  Flag as inappropriate

        I want to be able to format rows based on calculations as well. maybe include this as an option in a measure like

        if(id.value > 0, row.red, row.green)

        for example

      • sdegrootsdegroot commented  ·   ·  Flag as inappropriate

        I'd love a conditional formatting table! We have one table that is made up of different measures for different rows. Each cell containing the value needs to be color coded as Green for above target, yellow for in between and red for below. Crossing my fingers that this will be possible some day!!

      • WildmightWildmight commented  ·   ·  Flag as inappropriate

        yes, assigning color to certain values -ranges (just like in Excel) would be useful... please see if you can expand this functionality..thank you!

      • Tony GillTony Gill commented  ·   ·  Flag as inappropriate

        Coming from SSRS, this is really needed; I feel so powerless and not able to have that distinction in my powerbi reports as a result

      • Anonymous commented  ·   ·  Flag as inappropriate

        Maybe my situation is different, but my issue is that the conditional formatting defaults to a range approach between the colors. Sometimes I just need something as simple as GREEN / YELLOW / RED. It'd be nice to have more flexibility towards greater complexity AND simplicity for different report readers.

      • Massimiliano RivabeniMassimiliano Rivabeni commented  ·   ·  Flag as inappropriate

        In Matrix I would like to color some rows, for example subtotals, from the Head of the row to the last data of that row. The different level of subtotals have to be colored in different color.
        This is very helpfull for example with a cascading subtotals report.
        thk

      • Anonymous commented  ·   ·  Flag as inappropriate

        Having a printing option with preview and formatting support is needed for a table. Can you please improvise the current print option in PowerBI????

      • ViniVini commented  ·   ·  Flag as inappropriate

        As mentioned on previous comments, it's also a crucial requirement for us the ability to conditional format a row or column based on its header text rather than its cell value.

      • CoryCory commented  ·   ·  Flag as inappropriate

        Can we include the ability to word wrap column headers in the Matrix Preview visual and/or resize the column?
        Also, it would be great if we could rename a column value type. Example, in a column, I have "Count of Work Order" the data usually has double digit results or less (ie. 14, 27, 4) so the data takes up far less space than the header. Would it possible to either not include the "Count of..." part, or to left align the column data so I can resize it, or to allow word wrap on column headers and resizing.

      • Mark DuffillMark Duffill commented  ·   ·  Flag as inappropriate

        Allow any format for each condition. Allow multiple conditions. Support single format, rather than diverging, for each condition, and so have consistent colors for each range of values. Support dynamic values in setting conditions.

      • MA RobertsMA Roberts commented  ·   ·  Flag as inappropriate

        I was just thinking, with a dashboard we're developing, it would be great to assign the diverging point to something other than just the midpoint. In our case, assigning it to a specific value is worthless - depending on the slicers used, those values could change dramatically (especially if slicing on time and looking at only a fraction of the total). Much better to be able to say "when this is over 35% / 40% / 60% then color it."

      • AmyAmy commented  ·   ·  Flag as inappropriate

        The conditional formatting should be able to deal with any kind of column, not only on measurements. Also, It should be able to do whatever user wants, not only the color.

      • MarcMarc commented  ·   ·  Flag as inappropriate

        Addition to this: The ability to conditional format text. For instance when running a process and conditional format endstatus: "Success" as green and "Failed" as red colour.

      • GabrieliusGabrielius commented  ·   ·  Flag as inappropriate

        I would also need to format not only the background, but also on the text: introducing background color changes sometimes ruins the beauty of the report.

      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.