Chart to ignore Datime Timeline days but to show aggregate values for months quarters and years

[Anonymous]

Hello,

I have the following dateslicer that with the current selection yields the graph below.  This has one dimensions in x-axis, which are time and product, I have in the visual filter a top 1 by date to ensure it only brings me the last month of the selection on the slicer

However, if I selected the following date, it yields the following, the last dates are all in November in both slicers, my idea is for the for example to return the same output as the one below, which is the aggreggation of the month, this why independly of the the day selected in the dateslicer, it would always bring the overall of the month.

My current formula is:
CALCULATE(SUM(Product[volume]),ALL('calendar'[CalendarDate]))
I have also tried ALL('calendar'[Month]))) but is the same thing
The axis in the graphs are from a calculated column in the fact table

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

Could you try using the formula below to see if it works in your scenario? 

=
VAR y =
    MAX ( 'calendar'[Year] )
VAR m =
    MAX ( 'calendar'[Month] )
RETURN
    CALCULATE (
        SUM ( Product[volume] ),
        FILTER ( ALL ( 'calendar' ), 'calendar'[Year] = y && 'calendar'[Month] = m )
    )

Regards