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.
Here is the sample file
The expected behavior is that when I choose January 2017 start date, I should see projects 1, 2, 3, 4 and 5 as those fall into January, February and March. Project 6 is April so it would not appear in the table.
Thanks,
Petr
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.?
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.