Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello PB Folks,
I'm looking for a pagelevelfilter to show in a matrix automatically values from the firstworkingdate in this month till the lastworkingdate for month +2 (in this time line first workingday of Nov 2016 till lastworkingday January 2017).
I'm specially looking for a " rolling" filter for my endusers.
How to achieve this? I've got a datedimension table in my model.
Thanks!,
Best regards,
Marco
Hi @mvananaken,
Based on current description, it's not very clear about what is "rolling" filter. Would you please share more detailed information about what you need? If possible, please post some images about your expect output for further analysis.
Thanks,
Yuliana Gu
Hi Marco,
Drag the date column from calender table in the page level filters section, Select advanced filtering where you can see the calender, Select the appropriate value and you are done.
Hello @BhaveshPatel
Thank you. I specially looking for some " rolling" time intelligence for my endusers. I know the manually select option, but that's not where I'm looking for.
Best regards,
Marco
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |