Forum Discussion
Graph comparing 2 years cumulative count
Hello,
I have a table containing dates (dd/mm/yyyy) and other data.
I want to have a graph with 2 stack lines with:
* in x-axis, the 12 months
* in y-axis:
line 1: the cumulative nb of rows I had for a selected year in a slicer
line 2: the cumulative nb of rows I had for the previous year.
The cumulative nb must reset every year.
Can someone help. I even did not get the cumulative value.
HI Anonymous,
You can use the calendar table date fields on the line chart x-axis, then create a new table with two values(selected, previous year) to use as the legend of the line chart.
After these steps, you can write a measure formula to check the current legend value and current date values to redirect to different calculations. (for the selected part calculations, you need to prepare a unconnected table as source of slicer to interation with expression)Regards,
Xiaoxin Sheng
3 Replies
HI Anonymous,
You can use the calendar table date fields on the line chart x-axis, then create a new table with two values(selected, previous year) to use as the legend of the line chart.
After these steps, you can write a measure formula to check the current legend value and current date values to redirect to different calculations. (for the selected part calculations, you need to prepare a unconnected table as source of slicer to interation with expression)Regards,
Xiaoxin Sheng
Hi,
Share data in a format that can be pasted in an MS Excel file.
