Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ha...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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