Filter Bar vs Visual Filter Interaction

[Anonymous]

I have a matrix that has months along the top. If I filter by month in a visual filter, it hides the columns that have no data, if I filter by month on the filter bar, the months with no data remain but remain empty.

Is there a way to change the way the filter bar interacts with the reports so that it hides the empty columns?

[v-shex-msft]

HI @Anonymous,

I don' think you can use filter to achieve this, perhaps you can write a measure and use on 'visual level filter' to check and remove blank data bars.

Applying a measure filter in Power BI 

If you are confused about coding formula, it will help if you share some dummy data to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[Anonymous]

Sorry i cant see how that applies to the filter bar interaction?

[amitchandak]

@Anonymous , no option for interaction with filter pane