Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi power bi friends. Could someone help me out on this one please. So I have a table with static data (5 years & 1 year column) and with different measures (YTD column)
I wanted to have a conditional formatting with the YTD column like data bar that says if YTD column is nearing to reach the 1 year column, the color will be turned into orange, then if YTD is nearing to reach the 5 year column it will then turned into green.
See YTD column measures:
YTD Measure = IF (
HASONEVALUE ( 'KPI Financial Planning'[Category] ),
SWITCH (
VALUES ( 'KPI Financial Planning'[Category] ),
"$EBIT", [$EBIT Financial Planning],
"$Revenue", [$Revenue FP],
"Average Revenue/Client $", [Average Revenue/Client $],
"Client facing team members", [No. of Clients FP],
"EBIT% of revenue", [EBIT% of revenue FP],
"Enterprise Value", [Enterprise Value FP],
"No. of business locations", [No. of Business Locations],
"No. of Clients", [No. of Clients FP],
"No. of equity holders", [No. of equity holders],
"Revenue per FTE", [Revenue per FTE FP],
"Total FTE team", [Total FTE Team FP],
"Turnaround Days", [Turnaround Days FP],
0
))
Solved! Go to Solution.
@ronaldbalza2023 , While I am clear on you calculations. Color measure you can use .
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")
You can use color measure in conditional formatting using field value option
refer if needed
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
@ronaldbalza2023 , While I am clear on you calculations. Color measure you can use .
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")
You can use color measure in conditional formatting using field value option
refer if needed
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |