Display data for whole year of the selected month

[velvetine_123]

Hi,

I'm looking for a chart to display the entire year monthly data based on the selected month's slicer.

I have a calendar table and a fact table. The idea is if we select April 2023, the graph shall show Jan, Feb, Mar & Apr.

If we select Oct, it will show Jan - Oct. 

Appreciate all your help on which command to use !

Thank you.

[FreemanZ]

hi @velvetine_123 ,

not sure if i fully get you, supposing you have a data table like:

date	sales
8/1/2022	1
9/1/2022	2
10/1/2022	3
11/1/2022	4
12/1/2022	5
1/1/2023	6
2/1/2023	7
3/1/2023	8
4/1/2023	9
5/1/2023	10
6/1/2023	11
7/1/2023	12
8/1/2023	13

try to:

1) add a calculated table like:

dates = 
ADDCOLUMNS(
    CALENDAR(MIN(data[date]), MAX(data[date])),
    "YYMM", FORMAT([Date], "yy/mm")
)

2) related dates[date] to data[date] as 1:N

3) plot a slicer with the yy/mm column of a calculated table like:

slicer = dates

Don't relate it with any table. 

4) plot a visual with dates[yy/mm] column and a measure like:

Measure = 
VAR _currentdate = MAX(dates[Date])
VAR _slicerdate = MAX(slicer[Date])
VAR _result =
IF(
    AND(
        _currentdate<=_slicerdate,
        YEAR(_currentdate)=YEAR(_slicerdate)
    ),
    SUM(data[sales])
)
RETURN _result

it worked like: