Forum Discussion
hide slicer from a visualization
If you don't already have a date table in your model, I would def add one. There is a link to my favorite in this blog post: http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/. Once you have a date table with the right fields in your model and joined to your fact table, you could use the field that is Year and quarter to filter:
audreygerred Thanks for you reply.
I have tried this as well.
I have the filter pane below. So now what I wany is to select Years 2014, 2015, 2018, 2019, 2020, 2021, and up to 3 quarters of 2022. Like I want to include all 4 quarters for all the years and only to include first 3 quarters of year 2022. So I am unable to achieve this resuly from my Filters pane.
If you don't already have a date table in your model, I would def add one. There is a link to my favorite in this blog post: http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/. Once you have a date table with the right fields in your model and joined to your fact table, you could use the field that is Year and quarter to filter:
Thanks a million audreygerred
Thia really makes sense. I will add a new column by converting dates into Quarter and Year as a single field, rather than 2 separate. Thanks
You're very welcome! Glad I could help!