Forum Discussion

nick9one1's avatar
nick9one1
Icon for Helper III rankHelper III
1 year ago
Solved

only show values when visual is selected

I have a requirement to filter a visual if a column in another chart is selected.    Below I have a stacked column chart with data for each month. I want to only show data in the smaller column cha...
  • bhanu_gautam's avatar
    1 year ago

    nick9one1 

    Check Relationships: Ensure that there is a proper relationship between the tables that the two charts are based on. The relationship should be established on the date column.

     

    Cross-Filter Direction: Check the cross-filter direction between the two visuals. You may need to set the cross-filter direction to "Both" to allow filtering from the larger chart to the smaller chart.

    Interaction: Ensure that the interaction between the two visuals is set up correctly. You can check the "Edit interactions" option in Power BI to adjust how visuals interact with each other.

  • Anonymous's avatar
    Anonymous
    1 year ago

    HI nick9one1,

    The filter effect from relationship has high priority and will be applied on the source visutral table that visual used.
    If you want to fully customize the filter effects, you can create unconnected table and write measure filter based on table selection and current row contents and use it on visual level filter.

    Regards,

    Xiaoxin Sheng