Forum Discussion
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 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
9 Replies
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
It was the wrong one, thanks 🙂 I changed it:
https://drive.google.com/file/d/1THHewTS8uO-wBUF55w6fumiNzcqgIFPz/view?usp=sharing
Please check sharing options on that google doc. I couldn't access it.
