Want to disable automatic filtering on visuals

[hidenseek9]

Hello Power BI Community!

I have a problem with filtering.

What I want to do to have a chart like below showing a trend of

Sales and expense and have a dynamic timeline to adjust the dates on the chart.

BUT I want to show an expense percentage of sales for 2015/2016 on a card

unaffected by timeline visuals.

So what I have in below photo is that in 2015, the company had 1.6% of expense in comparison to 2015 sales.

If I choose to select just 2016 in a dynamic timeline visual, I still want the card to show 1.6% for 2015.

Is it possible? If so how?

I am calculating Sales, Expense and % with a measure.

Sales = calculate(sum(sales))

Expense = calculate(sum(expense))

% = divide(sum(expense),Sales,0)

I am using "Visual level filter" to filter the dates in 2015 to calculate the % for 2015.

I think I should be able to calculate 2015 Sales and Expense using a filter function in a measure,

but could not figure out how to do it.

Many thanks,

H

[Anonymous]

Hello,

in case I have heaps of visuals and wan to disable them all at once. Is there a way to do so or do I have to click on all of them?

Thanks

[kwest]

Yes, it is under Settings and Options>Options>Query Reduction. This video shows where to find it: https://www.youtube.com/watch?v=ZEWr8wYsF5Y

[Anonymous · Accepted solution]

@hidenseek9,

You can use the "Edit interactions" feature in Power BI Desktop.

Click on the timeline visual in your scenario, turn on "Edit interactions" under Format ribbon, then choose "None" in the Card visual, this way, you will get expected result.


Regards,

[JimT99]

I tried this with a card and it didn't work.  When I click on the card it filtersr the rest of the visuals 

[hidenseek9]

@Anonymous

Thank you for your advice!

It is working perfectly.

Many thanks,

H