Forum Discussion

oj62012's avatar
oj62012
New Member
3 years ago

Visual filter that filters another visual filter

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 conne...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
oj62012
New Member
3 years ago

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.