Monthly view of data when using relative date filtering

[Atreju67]

Hi all,

I am trying to bild a chart which makes my future sales of the next year visible by month. This shall always refer to the current month, so I selected the relative data filter and set it to next year.

Now, the chart is showing me all the expected sales per day, but I wish to sum these daily values up, so that I will see a monthly sum of expected sales.

Does somebody have an idea?

Thanks

[v-cherch-msft · Accepted solution]

Hi @Atreju67

You may try to use date hierarchy for your Date . Then select the Expand button on the top left of the visualization as below pictures. Here is the Microsoft document for your reference.

Regards,

Cherie

[Atreju67]

Great, that was easy!

Thank you very much