Filtering Table Visual By Calendar date

[Almantas32]

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 no active relationship (because I read somewhere that USERELATIONSHIP works correctly only with inactive relationships). 

1. is there a way to use crossfiltering with inactive relationships? 

2. If not, how would you recomend setting up correct cross filtering in this case that I am attaching:

https://drive.google.com/file/d/1THHewTS8uO-wBUF55w6fumiNzcqgIFPz/view?usp=sharing

Any help much appreciated

[HotChilli]

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

[Almantas32]

It was the wrong one, thanks 🙂 I changed it:

https://drive.google.com/file/d/1THHewTS8uO-wBUF55w6fumiNzcqgIFPz/view?usp=sharing

[v-kelly-msft]

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!

[HotChilli]

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

[Almantas32]

Sorry for that. Changed the settings:

https://drive.google.com/file/d/1THHewTS8uO-wBUF55w6fumiNzcqgIFPz/view?usp=sharing

[HotChilli]

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]

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]

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]

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?