Filter from Disconnected Table to Fact Table

Dear all,

Is there any possibility to filter the other tables, from a table that is not connected to them (disconnected table)?

I couldn’t make any relationships with other tables because the table with the name ForSlicer it’s created for a calculation that has to do with the previous quarter and if I make any relationship will lose my result. Now I need to use those quarters to filter them in the other tables (sheets) as well. The same quarters are also in the Calendar Table.

The reason why I need it is to put it in the Filter Pane to filter all pages.

I also made a video so you can see how the work is:

HI @edipgashi
Are you using EDNA date table? Is your date table marked as a date table? If you are you should be able to use EDNA date table to do your filter instead of creating another filter table.

If you aren’t i would recommend that you use EDNA Date table.

Providing a sample PBIX file would help the people in forum to help you with issue that you are having.

thanks
Keith

Hi @edipgashi,

We noticed that you have not responded to Keith’s request and questions last Feb 26, 2023. We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @edipgashi

We’ve noticed that no response has been received from you since Feb. 26, 2023.

We waited for the masked demo pbix file, images of the entire scenario you are dealing with, screenshots of the data model, details of how you want to visualize a result, and any other supporting links and details.

Due to inactivity, we’ll be tagging this post as Solved.

Should you wish to add your masked demo pbix file and other supporting links and details, you can reopen this thread.