topic Re: Disable specific filter in Visual in DAX Commands and Tips

Disable specific filter in Visual

joshua1990 — Sun, 13 Feb 2022 12:30:34 GMT

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.

Re: Disable specific filter in Visual

VahidDM — Mon, 14 Feb 2022 00:09:46 GMT

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/

Re: Disable specific filter in Visual

amitchandak — Mon, 14 Feb 2022 03:58:18 GMT

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-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

Re: Disable specific filter in Visual

Anonymous — Wed, 16 Feb 2022 09:43:29 GMT

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.

Re: Disable specific filter in Visual

PhilDanley — Thu, 12 Jan 2023 17:08:14 GMT

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.