Forum Discussion
Solved
cannot visualize previous month values in graph
I created a measure to calculate values of the previous month. But when I want to use a clustered bargraph to compare actual values and those of the previous month, the values of the previous maonth ...
- In conditional format you need to select the use formula in the setup it will allow you to make several ifs.
Hi Tairo,
The measures are based on context so when you make a chart with categories on axis and values vs preivous month you need to have the month as a context. Do the following to achieve the necessary setup:
- Place Month / Category on Axis
- Place Values / PM in Values
- Drilldown to lowest category and you will have the chart as below:
then just make the table as you need: with the following measure added:
Difference = SUM(TableName[Values]) - [PreviousMonthValues]
Regards,
MFelix
Thanks, that was the solution I was looking for.
Unfortenately the conditional formating of power bi don't allow if statemens so I used formula below to change the words.
Label = if ('TableName'[Perc. Diff] >= 0.2 || 'TableName'[Perc. Diff] <= -0.20, "divergend", "standard" )
- In conditional format you need to select the use formula in the setup it will allow you to make several ifs.