Forum Discussion
Chinese Lunar Calendar
Super UserWe typically create a single calendar and try to accommodate the calculations there.
You can create custom months, year and create their sort and incremental Ranks.
HEllo amitchandak
Thank you for you answer, I understand the logic
concernnig the question #2 , how do you male coexist in a slicer all the calendars making that the user can chose if he wants the standard, fiscal or lunar ? is their a check box thing to chose or a parameter somewhere ?
- Greg_Deckler
Community Champion
One method is to create a disconnected table with your choices of calendars. Then, you can have a measure select the appropriate date column from your calendar. Not sure of what your use cases are so hard to say exactly. You could also do this with bookmarks and buttons and that might work better if you have circumstances where dates are on the axis of a visual for example.
- amitchandak
This one is a bit tricky. Changing the calendar is easy. But change all calculation based on that would be a bit tricky
Like how you change measure using slicer. But you will have too many to change based on that
Or bookmarks to hide the complexity
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Thank you, I will try these options and tell you if it works
