Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 !
Solved! Go to 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.
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.
@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 , 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")
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |