Timeseries chart with date selections

[manojk_pbi]

Hi Friends,

I want to draw a Month on Month actual sales chart by MonthYear using below data. Please suggest how can we acieve this ?

Always one month Year will be selected in the filter to filter out the other data except this chart in the report.

My selection in report is November'24, chart is getting filtered to Nov'24 data but requirement is to show all the bars irrespective of my selection.

Jan-24	24
Feb-24	32
Mar-24	45
Apr-24	51
May-24	65
Jun-24	70
Jul-24	78
Aug-24	85
Sep-24	95
Oct-24	102
Nov-24	112
Dec-24	0

Thanks

[manojk_pbi]

thanks for the sample. 

[Anonymous]

Hi, @manojk_pbi 

Could you please let us know if  lbendlin's response resolved your issue?If you feel inclined, please consider marking ll  solution as such; this will assist other community members facing the same challenge in finding a resolution more swiftly.

Should you require any further assistance, please do not hesitate to get in touch.

I look forward to your response.

Thank you in advance
 

Best Regards,

Leroy Lu

[lbendlin]

what's the point of making the selection?

[manojk_pbi]

Actually page will show the current month's value on different metrics. Along with other KPI's user would like to see the sales month on Month. 

[lbendlin]

the standard approach is to feed your slicer from a disconnected table and then use measures to read the slicer value.

[manojk_pbi]

Okay. could you ppls share some reference links or any samples for me to understand and rethink on the design.

Don't we have any function to negate the selected values ?

[lbendlin · Accepted solution]