Forum Discussion

LasseL's avatar
LasseL
Helper I
10 years ago
Solved

Dynamic report filter list and visual list

Dear experts,

 

It might be a stupid question, but here it goes.

 

Does any of you experience that the report filter lists and visual filter list are not acting dynamically when something is filtered and knows how to resolve the issue?

 

In Power BI report filter I can put a filter on an attribute from one table and in a related table attribute list it is not reduced to only list the ones relevant to the first filtering.

 

I remember this was a pain in Excel some versions back, that when you put a filter on one column then the filter options in another we're not reduced, which limits the effectiveness and overview.

 

It works fine for graphs etc., just not for the filter lists.

 

Any ideas?

 

I am using a fact table with a star diagram of Dimension tables related through FKs in Fact Table and PKs in Dimension Tables.

 

Best regards,

Lasse

  • jahida's avatar
    jahida
    10 years ago

    Make sure all of your relationships are 2-way, and make sure that the visuals are set to filter each other (click on one, Format -> Edit Interactions, and make sure the little filter icon is selected on all the other visuals. Click Edit Interactions again to stop showing those). That's all I've got.

3 Replies

  • jahida's avatar
    jahida
    Impactful Individual
    10 years ago

    Make sure all of your relationships are 2-way, and make sure that the visuals are set to filter each other (click on one, Format -> Edit Interactions, and make sure the little filter icon is selected on all the other visuals. Click Edit Interactions again to stop showing those). That's all I've got.

  • AlexChen's avatar
    AlexChen
    Microsoft Employee
    10 years ago

    Hi,

     

    I assume you have 2 table: product and newSales like below. newSales.productId has a one-to-one connection with product.id.

     

    Product:

     

    newSales:

     

    Create a table visual and a column chart visual

     

     

     

    When you put a filter in report level filters list, you can see that visual level filter list do not change.

     

     

    But when you select a value in report level filter list, the value in visual level filter list will be changed accordingly.

     

     

     

    This behavior is by design in Power BI Desktop.


    Best Regards
    Alex