Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
  • DavisBI's avatar
    DavisBI
    5 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Which table does the Month selection come from? Certainly it does not come from dCalendario. If that were the case, you wouldn't see all those Month_year (mm/aa) values in the table. If you set it all up in such a way that the Month slicer does NOT affect what you see in the table, then there is no way to get what you want. What you have to do is have a second independent table from which you'll be selecting the reference year and month. Then you'll be able to extract the ref year and month for all the entries in the table and create the date you want. No other way around this.
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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!! 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      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.
    • DavisBI's avatar
      DavisBI
      Icon for Solution Specialist rankSolution Specialist
      5 years ago

      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!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thank you so much!! It is working perfectly!!!