Forum Discussion

Almantas32's avatar
Almantas32
Helper II
6 years ago

Filtering Table Visual By Calendar date

Hey guys,    I have a problem with cross-filtering. I am trying to filter a table visual by date from a column chart in the same sheet. The problem is that I use several inactive relationships and ...
Need Help
HotChilli's avatar
HotChilli
Community Champion
6 years ago

The file opens correctly.

Can you explain what you want more clearly please.

 

I see the date table with Inactive relationships for Date Opened, Date Closed.

I see the column chart and the bar chart which use a measure to count converted leads using Date Opened as an active relationship

I see the table at the bottom with Date Closed.

I see the month slicer at the top

  • Almantas32's avatar
    Almantas32
    Helper II
    6 years ago

    Thanks for the response. I am trying to use cross filtering to by date in Chart (1) to filter the table (2). 

     

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      Hi  Almantas32 ,

       

      Is your issue solved now?If so,could you pls mark as answered to close it?

       

      Much appreciated.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
      • Almantas32's avatar
        Almantas32
        Helper II
        6 years ago

        Hey, thank you for raising the issue. Acctualy I did not have any answer yet. The question is the same:

         

        Is there a way for cross filtering to work between tables that only have inactive relationships between them?