Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
84 | |
67 | |
63 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |