Visual filter that filters another visual filter

[oj62012]

Hi all, 

I wanted my 'Report frequency' filter to affect filters on another filter. My queries and their relationships are set up as per below: 

For context, the date table ('Dates') is connected to the compliance summary table ('Date reported') based on their corresponding date values. Similarly, the Legislation table (Rule or section number) is also linked to the compliance summary table (rule or section number) using the respective rule or section numbers as the connecting factors.

All three tables include a field named 'Reporting frequency,' which indicates whether the reporting is done on a quarterly or half-yearly basis. In the Legislation table, each rule or section is classified as either reportable quarterly or half-yearly. Similarly, in the Date table, each date is associated with a specific reporting frequency, which can be either quarterly or half-yearly.

The outcome that I want to achive: 

I want the Reporting frequency filter from the Date table be able to filter the Legislation table. For example if I choose Quarterly in the ‘Reporting frequency’ filter all rules/section number and obligation themes that are reportable quarterly will show on the filters to the left. Currently the Legislation table is directly connected to the Compliance summary which is also what I want because I want them to filter the graph. PLease refer to my visual below. 

Thank you and I appreciate any help I could get. 

Kind regards.

[v-stephen-msft]

Hi @oj62012 ,

To filter the Legislation table based on the Reporting frequency filter from the Date table, you need to make sure that the filter direction is from 'Dates' table to 'Legislation' table.

Please kindly refer to Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn for more details about corss filter directions.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[oj62012]

Thanks Stephen. 

I tried that before and it worked. However, the because there is no connection between the legislation and the summary table, the legislation table can't filter my graph (which is from the compliance summary table). My goal is to have a flow and effect filter process in the filters. For example, if I choose half yearly then the Obligations theme from the legislation table will show all the relevant themes that are reportable half yearly. And then choosing a legislation theme from the list will affect the values on my graph based on the chosen theme.