Forum Discussion
Timeseries chart with date selections
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
7 Replies
what's the point of making the selection?
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.
the standard approach is to feed your slicer from a disconnected table and then use measures to read the slicer value.
thanks for the sample.
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
