March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi Team,
I have the following data
and date table is defined as follows
Solved! Go to Solution.
@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
@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
@Jos13 , see if these two blogs can help
User | Count |
---|---|
122 | |
99 | |
89 | |
73 | |
65 |
User | Count |
---|---|
138 | |
115 | |
115 | |
98 | |
98 |