Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I would like to ask you about conditional formatting regarding table chart. Is there a way to add a background color for values from FY19 column if the value is smaller/bigger comparing to value in FY18 column.
Thanks,
Asia
Solved! Go to Solution.
@joannasokolowsk , have year measures like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
diff = [This Year]-[Last Year ]
If date is selected
Create a color measure and use that is conditional formatting using field value option
if([diff] > 0, "green", "red")
refer for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Please follow below steps
1. Create a measure to calculate difference between two financial years.
3. Your final output is below
let me know if you need more assistance in this. I hope this should resolve your concern.
Proud to be a Super User!
Hi, @joannasokolowsk
Yes,the conditional format is based on some field. If you have 20 sets of such comparisons, then it is inevitable that you need 20 such fields (column\measure) as the basis for judgment.
Best Regards,
Community Support Team _ Eason
Thank you!
Thanks for your suggestions! If I need to compare 20 such columns I guess I need to create a mesaure for all such cases, right?
Thanks,
Asia
Hi, @joannasokolowsk
Yes,the conditional format is based on some field. If you have 20 sets of such comparisons, then it is inevitable that you need 20 such fields (column\measure) as the basis for judgment.
Best Regards,
Community Support Team _ Eason
Please follow below steps
1. Create a measure to calculate difference between two financial years.
3. Your final output is below
let me know if you need more assistance in this. I hope this should resolve your concern.
Proud to be a Super User!
@joannasokolowsk , have year measures like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
diff = [This Year]-[Last Year ]
If date is selected
Create a color measure and use that is conditional formatting using field value option
if([diff] > 0, "green", "red")
refer for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |