Condtional format matrix

Question

Hi,&nbsp;I have a matrix with values in powerbi. I want to highlight when the value in a row is lower than a previous column.See below the example with the highlighted values.Could this be done with conditonal formatting?&nbsp;&nbsp;&nbsp;Thanks&nbsp;

amitchandak · Answer

What do you mean by the previous column? In case it is time, you need to create a previous period measure and use diff to color

anonymous · Answer

yes, the columns are labeled per yearmonthnr. So what would the measure be? And how do I use conditional formatting on a measure with is not used on the matrix?

v-lianl-msft · Answer

Hi Anonymous&nbsp;,&nbsp;You can refer to this thread:https://community.powerbi.com/t5/Desktop/Conditional-Formatting-Matrix-Visual/m-p/876777&nbsp;If the problem persists,could you please share sample data or sample pbix?(Please mask any sensitive data before uploading)&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Thanks for the link.I have created a new measure previous period and a measure which calculates the difference between current and previous period.Only thing is that the underlying rows are highlighted but not the total.Three columns are shown per period.&nbsp;Actual - Previous Period -&nbsp; Delta&nbsp;&nbsp;&nbsp;Thanks.

v-lianl-msft · Answer

Hi Anonymous&nbsp;,&nbsp;Unfortunately, this feature is not implemented yet. You can vote for this idea:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33425191-conditional-formatting-doesn-t-applied-to-a-grand&nbsp;&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Condtional format matrix

5 Replies

Related content

condtional formatting

Matrix formatting

Matrix Row Conditional Formatting

condtional formatting

Formatting Matrix Visuals