Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
I have a report where I need to filter my data based on trendtype.
The columns I have are Date,TrendType and Sales as below
So I created a slicer called trendtype having 4 values daily, weekly,Monthly and Quarterly
So data is already aggrigated for daily , weekly and monthly (dont have data for Quartely)
If user selects daily in slicer then I need to show last 30 days data
Weekly then last 12 weeks data and also I need to show WTD data too
Monthly then last 12 Months data and also I need to show MTD data too
Quarterly then last 4 Quarters data and also I need to show QTD data too
Could any one please help , how to do this
Hope this will help you
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |