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.
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.