Forum Discussion
Solved
hide slicer from a visualization
I have 3 pages on my Power BI desktop dashboard. I am using matrix visualization and slicer on each page. The slicer used on each page is different. What I want is to apply the slicer to use it as ...
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!