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:
If you are saying you want to filter the matrix and save it that way for the report users and you do not want them to be able to see or interact with the filter, click the matrix you want to filter to activate it, add the field you want to filter by (if not already there) to the Filter Pane under 'Filters on this visual', filter to what you want, then click the icon on the filter that looks like an eye - this will hide it from report users.
This is unhidden:
This is hidden
If this solves your issue, please mark as solution.
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!