Forum Discussion
Problem with filters
Hello, I have a problem with a filter in a calendar table and I am not being able to figure out what I am doing wrong. The issue seems simple, but the filter expression that I am using doesn´t work t...
Hi, Anonymous ,
If you look at the screenshots I provided, your requirements have been met. But I may need to add that slicers are not related to the main table, you can test it again.
Best!
Mark this post as solution if this helps,thanks!
Hello Anonymous, all the information comes from the same calendar table (dcalendario). It is showing all the Month_year because the interaction between the slice and the table is inactive. I need to show the Month_year.
I didn´t think about creating a second table, it is a good way around. I am going to try and will let you know if works.
Thanks for the insights!!
So you don't have much choice but to have another, disconnected table that will host your years and months from which you'll be able to select your ref pieces of time. And it's not a workaround. It's the ONLY and in fact the only correct way to do what you want.