I have this table :
I want to make a conditional formatting on value like this :
Is there any way to do this with conditional formatting?
Go to Solution.
@Fragan , You can use time intelligence and date table for This Month Vs last month
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
Use color grouping on Diff
Or create a color measure and use it with "Field" option in color grouping
Color sales = if([Sales MTD] -[sales LMTD]>0,"green","red")
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!