Forum Discussion
Slicer
Create a calendar table, or a year-month table if that's your smallest date granularity.
It's best practice anyway, and it would yield a year-month field that's independent from the fact table.
If you have no data for 3/2022, for example, your calendar table would still have that month.
Create a relationship beytween 'Calendar'[Year-Month] and 'Data Table'[Year-Month].
Use the 'Calendar'[Year-Month] in the slicer.
Hey thanks for the solution. That worked fine. I tried with a new dummy Excel sheet as you said and its working exactly.
I will accept this as a soluiton to my question. Once again Thankyou 🙂
Your best option is to unpivot the A-E columns in Power Query.
Unpivot columns - Power Query | Microsoft Docs
Do that, and the A-E would be a field you may add to a slicer, just like months.
Unpivoting is ok but I have the data with null values which will be filled out in future. So when I unpivot Iam lossing the months which are having null data. Is there any option for doing this please?