Forum Discussion
Filtering week from Date Table
Hi Team,
I have the following data
and date table is defined as follows
Jos13 - Ah, that wasn't really clear from the original email. Well, a few ways of solving that. I suppose the easiest way would be to create a complex selector measure that returned 1 if there were sales in a wee and 0 if not and then just filter on that. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
5 Replies
Jos13 - I am not quite following this one. Are you saying that you only want to display the last two weeks of any month in your week slicer?
Hi Greg_Deckler ,
It is not like that. I want to display those weeks which have sales. In the above example, I have sales for the last two weeks of March. So If I select March, I want week4 & 5. Similarly If I have sales for whole April, I want all the weeks in week slicer when April is selected.
If the current format is followed, sales will be blank when the user selects week 1,2 or 3 for March.
Thanks,
Jos
Jos13 - Ah, that wasn't really clear from the original email. Well, a few ways of solving that. I suppose the easiest way would be to create a complex selector measure that returned 1 if there were sales in a wee and 0 if not and then just filter on that. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
