Parameter Slicer

[koorosh]

Hello All, Why the chart shows just one month and does not act like the following link, Please?

https://cloudbi.com.au/show-data-for-the-last-n-months-based-on-a-selected-month/

https://drive.google.com/file/d/1HZuqB-_khVnsa9LKn7zzHBgDOrt4TPhB/view?usp=sharing

[Anonymous · Accepted solution]

HI @koorosh,

I think this should be related to the date slicers, it has higher priority than expression calculation ranges and filter not matched date ranges which are expanded by the measure formula. 

You can try to remove the filter selection to confirm this.

Regards,

Xiaoxin Sheng

[koorosh]

It seems the Date_Helper table should be created and its YearMonth column used for the bar chart!