rvgolovin
Microsoft Employee
9 years agoStatus:
Completed
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.
34 Comments
- nishalitNew MemberSince the creation of this idea back in 2016, we have added much more flexibility to conditional formatting. Two particularly powerful updates include... Format based on rules: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2017-feature-summary/#conditionalFormatting Format based on another column: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting Of course we will continue adding even more functionality to conditional formatting, but this idea now to generic to be useful. There are many specific conditional formatting ideas on this site, so please, if we are still missing something you need, vote on it so we can continue to add valuable updates for you!
- gabrielius1New MemberI 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.
- marcv1New MemberAddition 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.
- amyyuNew MemberThe 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.
- MARoberts
Advocate I
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." - markduffill
Advocate I
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. - thojeNew MemberConditional formatting based on text values are MUCH needed
- pbiideas1New MemberThis is a basic requirement !!
- abhijitNew MemberHaving a printing option with preview and formatting support is needed for a table. Can you please improvise the current print option in PowerBI????
- mpangaNew MemberStrongly supporting this
Recent ideas
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael3 hours agoHelper INew3Views0likes0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor5 hours agoSuper UserNew2Views0likes0CommentsNative Page-Level Security (PLS) or Dynamic Page Visibility based on RLS Roles
Description: Currently, Power BI provides robust Row-Level Security (RLS) to restrict data rows, but it lacks a native mechanism to restrict or hide entire report pages based on user roles or USERPRI...Erick1815 hours agoNew MemberNew3Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx17 hours agoNew MemberNew5Views0likes0CommentsPower BI Subscriptions: Suppress OOO Replies and Improve Sender & Management Options
With the recent changes to Power BI subscription email delivery, Out of Office and other automatic replies can be returned to the individual subscription owner. For automated subscriptions sent to l...svcrowell18 hours agoNew MemberNew18Views2likes0Comments