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

Is the attached pbix the correct one?

 

"I am trying to filter a table visual by date from a column chart in the same sheet" - All I can see is a table visual with 'id' and 'Count of ID' and there aren't any inactive or active date relationships in the model.

 

If it is the right pbix, show us what your desired result is

  • HotChilli's avatar
    HotChilli
    Community Champion
    6 years ago

    Please check sharing options on that google doc. I couldn't access it.

      • 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

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

    Hi Almantas32 ,

     

    Pls share your file with public access,we cant get your file via your link.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!