Filters

[sunilpatel]

Trying to create a filter to view by different modes like Month, Date or Week so that next filter should show the dropdown as related. Like if month then only Jan, feb etc. if week, then the week date. and if date then all the dates from model

please help

Thanks in advance

[v-deddai1-msft]

Hi @sunilpatel ,

You can use group function in power bi to group your data in year month or 7 days. As mentioned in https://www.youtube.com/watch?v=_ZT4TT0S_4k

If you want to use slicer to control it , you need to create a disconnected table with Month, Date and Week row, use the switch function in all your measures in the report. It could be a tough work. There is no direct function for it now.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai