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 🙂
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,
Thank for the idea. Let me show my table exactly. So that it would be very easy to understand and find a solution luckily
In the above picture, I want to make the highlited column as the slicer. This is the exact data
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 🙂