Forum Discussion
cannot visualize previous month values in graph
- In conditional format you need to select the use formula in the setup it will allow you to make several ifs.
Hi MFelix,
Thanks a lot for your response.
The formulas are working fine,
I am collecting a large number of customer remarks for different categories. I am trying to build a dashboard that gives a warning when there is a large increase of customer remarks compared to a previous period. As an indication that there might be something wrong with categoires that exceed a certain value.
So to answer your question I like to the month itself, meaning: When there are no values in March I still want to compare April to March. But when I place PrevMonthValue in a graph, the values are not visible.
Regards,
Tairo
I have made a chart using the date (month) and values column and pv month measure and it worked well. For example in February it shows 85 in pv month so matching january.
How are you placing the columns / measures on your chart?
Hi MFelix,
Did you made chart in the example file?
When possible I like to create a clustered bar graph with on the x-axis the categories and on the y-axis the #. As values I want to use actual month and previous month.
Next I am placing date, catgory, actual and previous value, difference in a table. I want to use conditional formating to make the background color red when the differece exceeds a certain value.
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