only show values when visual is selected

[nick9one1]

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 chart when one of the columns in the larger chart is selected. 

I have tried using the measure 

IsDateFiltered = INT(ISFILTERED(Query1[Date]))

I have applied this to the smaller chart as a filter (is 1)

when selecting a column in the larger chart, the smaller chart always stays blank. 
I have double whened this by adding the metric as a visual and it does change to 1
e.g.

If I use a slicer with the same date fields it works

[bhanu_gautam · Accepted solution]

@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]

Hi @nick9one1 ,

Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

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

[bhanu_gautam · Accepted solution]

@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.