EYMARD on 21 Jul 2016 20:57:13
I need to have the possibility to add conditional formatting in Matrix chart as we can do in Cross table in Excel.
Thanks
Administrator on 29 Nov 2016 04:19:05
We've added support for conditional formatting on the matrix visual in the November release of Power BI Desktop. To learn more, check out our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/
- Comments (38)
RE: conditional formatting in matrix
We need conditional formatting based on field but to be applied on entire ROW.
RE: conditional formatting in matrix
Kim Are you also adding the option to make a risk matrix? With colloring options? Green for low impact and low risk to red for high impact and high risk? That would be great!
RE: conditional formatting in matrix
This is a good idea, although again much of what is going on here seems to be bringing Power BI in line with Excel - or rather with a baseline set of features people use in Excel. At some point I hope it occurs to someone that convergence may make more sense than duplication.
RE: conditional formatting in matrix
Yes, a heat map (conditional formatting) component in the matrix table would be great.
RE: conditional formatting in matrix
Would be great if this is available for Multi-row card.
There should be an option for coloring the bar base on a field's value.
RE: conditional formatting in matrix
Kim said: "Conditional formatting is already available on the table visual"
That's entirely true, but only per (1) column and that column must have an aggregration/summarization (sum avg etc). It does not work for "do not summarize" values. It should also be possible to format an entire row in a table based on the value of 1 cell / column. Tables and matrices should behave almost identical whenever possible.
RE: conditional formatting in matrix
That'll be great.
Can't wait to see this happen in matrices as well.
Our report consumers just love the conditional formatting in the table grid but we would be better served with a matrix.
Thank you
RE: conditional formatting in matrix
I have the same requirement. For each cell in matrix, I can format it by condition like we do in excel pivot table.