Forum Discussion

kent-culpepper's avatar
kent-culpepper
Frequent Visitor
2 years ago
Solved

Visual Not Filtering As Desired

This may be a constraint.. not sure.

 

I have selected a slice (Technology) in my treemap visual (top-right)-- but my stacked chart (top-left) doesnt seem to filter for this selection (altho I can see it is affecting it when viewing the "Filters affecting this visual"). My expectation would be that the legend\bars would only display items of the Technology sector.

It is affecting a couple other charts as expected (waterfall and scatter).

 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  kent-culpepper ,

     

    These two Visual in the use of fields whether to come to different tables, if so, you can check the relationship between the two tables, if the two tables are filtered Single, and Table1 filter Table2, then Table1 can filter Table2, but Table2 can not be filtered Table1, you can change it to Both.

     

    Refer to :

    Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

    If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

     

    Best Regards,

    Liu Yang

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  kent-culpepper ,

     

    These two Visual in the use of fields whether to come to different tables, if so, you can check the relationship between the two tables, if the two tables are filtered Single, and Table1 filter Table2, then Table1 can filter Table2, but Table2 can not be filtered Table1, you can change it to Both.

     

    Refer to :

    Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

    If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

     

    Best Regards,

    Liu Yang

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