Show only filter information in column graph

[mikro87]

When I filter my site for the Data in the blue column graph, I still see the amount for that month, but I only want the filtered data to be displayed. 

How can I do that?

[v-gizhi-msft]

Hi,

I am confused about your requirement, and i create a table to test.

It works well after filter on one row in table visual:

If i misunderstand it, please give a result render you want as a screenshot for me to help you further.

Best Regards,

Giotto Zhi

[mikro87]

can you try to sum two values in the column chart and then filter it?

[v-gizhi-msft]

Hi,

If i sum column [sales] and [budget] as a new column, it still works well here.

Could you please share your data with me and remember removing any sensitive data.

And please give an example about the result you want.

Best Regards,

Giotto Zhi 

[mikro87]

I guess it has to do with highlighting. It also happens in pie charts when I drill down.

Could this be it?

[SpiroswayGR]

@mikro87 

Are you filtering the data with Slicers?

Also how many tables do you have ? maybe relation missing between tables so slicer / filter not working there.

[mikro87]

I'm using a table where i select a row.

The filterinng is working, but it's just display in this way I can't use