Forum Discussion
Filtering table based on a value from a slicer
Great solution, like it a lot. Is there a way to order the months in the forecast start slicer? January followed by february etc.?
You are welcone. If my reply helped, please mark it as Answer. I would suggest the approach of having 2 slicers - one in which you select the year and another in which you select the month. Create a month_order table and build a relationshop from the month column in the calendar table to the month column of the month_order table. Using the RELATED() function bring over the order column from the month_order table to the calendar table. Then use the Sort by column feature.
Download the file from here.
Hi,
You may refer to my solution here. I have had to create a calendar table and then create 2 relationships - one from Table1 to the calendar table and another from Table3 to the calendar table. I then rewrote your mesaure as well.
Hope this helps.
Great solution, like it a lot. Is there a way to order the months in the forecast start slicer? January followed by february etc.?