Group by year when no month is selected

[bneuf]

Hello Community. I'm new to Power BI Desktop. I have created view where I am using two slicers (years and months) for the X axis. I want my chart to group by year when no months are selected. Currently, my chart looks exactly the same when all months or no months are selected. What am I missing? Can someone help?

[Padycosmos]

If you are using SWITCH() ,

SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])

In the else condition, you can use the measure [Total Sales], which would include Sales for all the years.

Though an unrelated video, you can see the above being used here

https://www.youtube.com/watch?v=inJ3Yt7ay30

[freginier]

By default the slicer select all data even if you don't choose an item, so empty or all selected it's the same.   

Does you slicer work when you select only one month ? 

[bneuf]

Yes, if I selected one or multiple months, the data will segment to those months. For example, if I select "Janaury" with both years selected, I will see to bars - one for Janaury 2021 and another for Janaury 2022.

[freginier · Accepted solution]

So everything works. You can't define a different agregation level (month / year) using a slicer