Keep all months & 2 years in chart bar

[PHDurand]

Hi community,

Let me share my issue with you: I want to show in a bar chart the sales from this year & prior year (calculated with a DAX formula SAMEPERIODLASTYEAR) by month.

I did it easily using slicer and selecting 2 years and showing the months.

But to make filtering easier for users, I would like to use a slicer and select only the last period I want to show (as the page also includes monthly data).

Below you see where I am in my report:

- On the top row, I nearly got what I want but to do so I need to select all the months in the current year.

- On the second row, it's the slicer as I would like it to be used (only selecting one month) but in this case, the charts are only showing one month.

- On the bottow row I tried to split the slicer (one for the year and one for the month). In this case I got all the months but only the current year (I'm loosing the prior year comparison).

Does anybody has an idea how to do it ? If not, I will need to use unfriendly slicers but at least it would work.

[v-haibl-msft · Accepted solution]

@PHDurand

Could you please post some sample data for your tables, and the DAX formula for the measure?

You can take a look this thread to see if it helps.

You can also try to use the Timeline slicer so that you can select months just by dragging which should be easier.

Best Regards,
Herbert

[PHDurand]

Hi,

Thanks for the link. Indeed this solution applies very well to my issue. I created the same table and just adjust the measure and it works.

Thanks