Show values for each month in a column chart up to the selected month in slicer

[Sagejah9]

Hi

I would like to show my measure for all the months up to the selected month in the slicer included. However my measure is calculating for all the month therefore showing all months. 

for example if I select Apr in the slicer I would like it to show from the beginning of the year (Jan) TO apr

 and months after return blank

[v-angzheng-msft · Accepted solution]

Hi, @Sagejah9 

1. To create a calculated table(Slicer)

_Slicer =
SELECTCOLUMNS ( 'Table', "Month", MONTH ( 'Table'[Date] ) )

 2. To create a measure:

Measure = IF(MONTH(MAX('Table'[Date]))<=MAXX(VALUES(_Slicer[Month]),[Month]),1,0)

3. add a slicer visual with month field from table Slicer.

4. Filter the visual when measure is 1 in filter pane.

resutl:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sagejah9 , if select one month and want to show 4-month on-trend, You need to have an independent date table.

refer this

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI