Suggest some good visual for this kind of Data

[Anonymous]

Hi Team,

Below is my sample data, I wanted to show all 4 Qts data and its difference (Met & Not Met). I want to show all domians and its Qtrly update. Please help me 

Domains	Q1	Q2	Q3	Q4
A	Met	Not Met	Met	Not Met
B	Not Met	Not Met	Met	Not Met
C	Met	Met	Met	Not Met
D	Not Met	Met	Met	Not Met
E	Not Met	Met	Met	Not Met
F	Met	Met	Not Met	Met

Thanks in Addvance !

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

In the query editor, select "Domains" column and click "Unpivot other column".

Create measure like below and apply it to conditional formatting.

Measure = IF(MAX('Table'[Value])="Met","blue","grey")

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Matrix with conditional formatting. You can only show color based on Met and Not met (use same color for font and background) You can use color measure

example

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK("Table"[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK("Table"[Year],2014)>2018,"red","yellow"))

Color = if(FIRSTNONBLANK("Table"[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK("Table"[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[Anonymous]

@amitchandak ,

I dont have year column, please can yu send me the example.

Thanks !

[amitchandak]

@Anonymous , those were examples, you have to measures like assuming q1, q2 are columns else use column name

if max([Q1]) = "Met", "green", "red")

if max([Q2]) = "Met", "green", "red")

[Anonymous]

@amitchandak 

Here is the error.