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 🙂
Unpivoting will get you the desired solution.
Yes, right now, you will be left with just 2022.
As time progresses, more values would show up.
Please give unpivoting a try.
You can then test it with dummy data for other years and see how it works.
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 🙂