How to Remove the Highlighted Part of the Visual

[Nimai123]

For a given Scenario I have 2 Visuals a table and a Bar graph if I click on the table the graph gets filtered depending upon what I have selected.

Given below I haven't clicked on any country so I am able to see the bar graph as total value.

Here when I click on a single county from a table a bar graph is filtered depending upon the requirement.

My aim is that I should see the whole data of the country Mexico(which can be achieved with the help of Slicers) instead of the highlighted part so that it is easy to interpret.

Do we have any visual or a workaround for this?

Thanks in Advance.

[amitchandak · Accepted solution]

In interaction, you have an option for fill and filter. use filter. Also right-click you can apply the value.

[Pragati11 · Accepted solution]

Hi @Nimai123 ,

Consider the following 2 sample visuals and then follow the steps below:

1. Click on the right table visual. Go to FORMAT tab on the top and Click Interactions:

    

The RED highlighted icon is for HIGHLIGHT, which is currently happening in your case.

The BLUE icon is for FILTER, which you are looking for - SELECT it.

2. Come out of this EDIT Intercations, then select a cell value on table visual, the left BAR CHART visual will filter for the selected value as follows:

If you need more information on interactions in Power BI, refer following mink:

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

If this helps please give Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[amitchandak · Accepted solution]

In interaction, you have an option for fill and filter. use filter. Also right-click you can apply the value.

[vothanhthu]

Thank you very much, this solution has helped me