Disable highlighted area in Visual

[joshua1990]

Hi all!

I have a simple report that shows me the sales per week on a running bar chart (week on x axes) for the past 20 weeks.

Then I have a matrix that is filtered using a slicer on the latest week. This chart shows me the sales per article for the selected week.

Now I would like to click in the matrix on an article and get the sales per week in the bar chart.

For now it works partly. The bar chart shows me values (sum) above millions (dimension).

The matrix shows me the sales with values like 10, 100 or 1000.

When I click on the matrix then I get this sales volume in the bar chart highlighted, but I can't see this because it is to low compared to the total sum.

Is it possible to get the past sales volume in the bar chart for the selected article in the matrix without the total sum when selecting?

[amitchandak]

@joshua1990 , Better change interaction to filter.

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

[joshua1990]

@amitchandak : Thanks, but what do you mean here specific? As mentioned, the interaction between both visuals is working.

[v-easonf-msft]

Hi, @joshua1990 

Have you tried changing the behavior of the interaction between both visuals from 'highlight' to 'filter'?

Best Regards,
Community Support Team _ Eason

[joshua1990]

@v-easonf-msft : Could you please show me how to do this?

[v-easonf-msft · Accepted solution]

Hi， @joshua1990 

Please refer to these tutorials.

YouTube:

How to Change Power BI Chart Interaction Setting from Highlight to Filter or None 

Changing The Interactions of Your Visuals in Power BI 

Visualization Tip Change to Filter instead of highlight Control the Interaction in Power BI 

If I misunderstood, please share relevant screenshots to further illustrate your needs.

Best Regards,
Community Support Team _ Eason