Matrix Color Formatting

cyborgandy — Thu, 22 Sep 2022 04:57:08 GMT

Hi All, I have below dataset.

Compnay Name	Spend	Fiscal Year	Department	Divison
Water	5000	2022	Sea	A
Rock	10000	2022	Forest	B
Salt	3000	2021	Sea	A
Rock	1000	2022	Forest	B
Water	6000	2021	Sea	A
Salt	20000	2022	Sea	A
Water	50000	2021	Sea	A
Water	50000	2022	Sea	A

I have created below matrix in Power bi:

Division	Sea Spend	Forest Spend	Top Company Name In spend	Spend Of Top Company
A	134000	0	Water	50000
B	0	11000	Rock	10000

Now I want to do color formatting for Sea Spend and Forest Spend , that if the unique count of company count is below or equal to 2 in that case color the row as green , if more than 2 then red however the unqiue count is not in the matrix , it is availble in the dataset, also under top compnay name i want to show the top company name with highest spend and in Spend table how much they have spend.

Re: Matrix Color Formatting

Greg_Deckler — Wed, 21 Sep 2022 13:08:34 GMT

cyborgandy Maybe:

Color Flag Measure = VAR __Table = DISTINCT('Table'[Company]) RETURN SWITCH(TRUE(), COUNTROWS(__Table)=2,1, COUNTROWS(__Table)>2,2, 0 )

Use this measure in your conditional formatting based on Rules.

Re: Matrix Color Formatting

cyborgandy — Thu, 22 Sep 2022 04:56:26 GMT

Hello Greg_Deckler , This DAX didnt work.any other suggestion

topic Re: Matrix Color Formatting in DAX Commands and Tips

Matrix Color Formatting

Re: Matrix Color Formatting

Re: Matrix Color Formatting