Forum Discussion
Highlight increase
Not sure if this is possible, i would like to highlight percentage increase by month.
Eg.
I have a table where column has month and products are in row
I would like highlight in red the value if value is greater than 10% when compared to this month vs last month.
Well, that depends on your data.
You need a calendar table https://exceleratorbi.com.au/power-pivot-calendar-tables/
and time intelligence calcs. https://exceleratorbi.com.au/dax-time-intelligence-beginners/
Typically
total = sum(table[column])
total last month = calculate([total],dateadd(calendar[date],-1,year)
chg = [total] - [total last month]
% chg = divide([chg],[total last month])
6 Replies
Yes it is possible, but you haven’t provided any detail. So, you need to
1. Write a measure for this month
2. Write a measure for last month
3. Write measures for chg and %chg vs last month
4. Apply conditional formatting on your result based on the % chg measure.
- Thanks for replying Matt, so what measure do I need to write for this month n last month?
Well, that depends on your data.
You need a calendar table https://exceleratorbi.com.au/power-pivot-calendar-tables/
and time intelligence calcs. https://exceleratorbi.com.au/dax-time-intelligence-beginners/
Typically
total = sum(table[column])
total last month = calculate([total],dateadd(calendar[date],-1,year)
chg = [total] - [total last month]
% chg = divide([chg],[total last month])
