Disable specific filter in Visual

[joshua1990]

Hi experts!

I have a bar chart that shows the sales aggregated (total department) for the past on a weekly basis.

Then I have a matrix that shows our top 10 product sales. This matrix is filtered on the current week.

Now I would like to see the sales per product on the bar chart if I select one product in the matrix.

How is this possible?
When I press now on a product, then I just get 1 week in the bar chart. I would like to see the full horizon.

[v-rzhou-msft]

Hi  , @joshua1990

Do you want to remove the filter from the matrix in the bar chart? You can choose “None” in Edit Interaction function to remove the filter from the matrix in bar chart.

For reference: Change the interaction behavior

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilDanley]

Thanks RicoZhou. This worked perfectly. My column chart of yesterday's data can now be drilled down without affecting the two matrices which can be filtered by day/fiscal week.

[amitchandak]

@joshua1990 , One of the ways is to create a measure with all('Date'[Week]) or removefilters('date'[Week])

calculate([Measure], all('Date'[Week]))

Another is to have an independent date table, which is used in the measure of Matrix. This will more be suitable as the bar is showing the weekly trend

refer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[VahidDM]

Hi @joshua1990 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/