Currently, conditional formatting in matrix is based on all values of the matrix. I am looking forward to have it based on individual rows (a feature already available in Excel) Consider having mont...
9188040d-6c6100
6 years agoNew Member
Currently you can wrap all the measures into a single 'magic measure' which uses a switch statement and a disconnected 'column dimension' table to control which measures go into which columns. Then use the 'Magic Measure' to apply conditional formatting to each row. This avoids having to apply conditional formatting separately to each column value. - You will also need a separate measure that drives conditional formatting, if you want to do anything other than colour range formatting, e.g. KPI, or highlight specific rows with an indicator / boolean measure.
Recent ideas
Dynamic Labels for Subtotals and Totals in Power BI Matrices
Power BI should support dynamic expressions for subtotal and total labels in Matrix visuals. Currently, subtotal labels are static, which limits report usability and forces report authors to implemen...KellyMc50 minutes agoNew MemberNew1View0likes0Comments