conditional formatting in tables

[mribeiral]

It was implemented in charts but not in tables or matrixes.

[dhannon1]

You need to allow for conditional formatting based on a formula / value. Also allow for grouping / ungrouping of rows / columns by the user. Also greatly increase the color palette. Thanks!

[ThomasIvar62]

Any feedback from MS?

[VictoriaRosas]

This is a MUST HAVE!

[payne_jn]

Very important and basic for a viz tool.

[richard_eriksso]

Conditional formatting for matrix' and tables would push Power BI one step further to being the obvious BI choice!

[bsvannierop]

There is a possibility to manually set colors and conditional format (some) visuals. However I cannot use data from my dataset (for example different targets for different categories) to format my visuals. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6518993-set-colors-and-conditional-formatting-in-visuals is "completed" but I believe this is a too basic solution, not how it should be (as also mentioned in the comments there).

[Mike_D]

It would be very useful to be able to conditionally format the values in the matrix. Similar in fashion to the way excel automatically conditionally formats the cell background of a pivot from green to red. This would be useful for creating matrix views that compare dates such as order date vs. delivery date. With one date in rows, the other in columns, and the count of orders in values, colors on the value cells would give a great heatmap style view of the duration and volumes of your orders.

[dave_robinson]

Not only columns and values. There is also a need for formatting by row. Example each row contains a part number and each column is a location. It would be nice to highlight top 3 values for that row. Or highlight values above row average.

[pedro8]

Botz idea is great! ("Utilize the colors defined in an MDX Cube to a cell on a Matrix or table")

[pedro8]

Hi Will, I have uploaded a sketch of what I think would be a good interface for formatting tables, which follows the current Power BI UX: http://postimg.org/image/6vy8s9fpz/ It covers what I think it is fundamental table formatting features missing from Power BI.