Forum Discussion
Post ProdigyShowing Data Based on weeks, months
I was wondering what is the best way to work out showing data based on weeks and months. So for example, if the user selects dates between date A and date B but wants to see the data grouped by month but also has an option to see the data grouped by weeks.
Thanks
6 Replies
- pratyashasamal
Memorable Member
Hi stribor45 ,
You can create a slicer . Please refer to this link , it has a similar use case .
https://community.fabric.microsoft.com/t5/Desktop/Change-time-period-week-Month-Quarter-on-slicer-selection/td-p/2045991
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
stribor45This looks like a great solution for me but it doesn't have step-by-step instructions on how to accomplish this. I was able to manage plugging in my own data but was hoping to have step by step for better understanding
- stribor45
I was able to make some progress so I will post here once when I am done.
- stribor45
How is the Calendar table and Sales tables one to many relationship when in each table there is only one date?
mlsx4If you use a matrix you can go deeper or not as you need:
For instance, here you can see Month and day, but you can keep it closed with +/- buttons.
- stribor45
I watched tutorial video Slicer about this and I am very confused about DATESMTD function. In the video, he has a slicer with "YTD", "MTD" and so on. He is using the measure to find whether the dates in the table contain dates that are in the current month. How does this line of code know (true/false) dates that are in the current month?
dim_Date is the custom table for the dates, weeks etc
New Date table is the table that contains unique values from dim_Date table
VAR _mtd = MAX(dim_Date[Date]) in DATESMTD('New date'[Date])Any help would be much appreciated
