Forum Discussion
Want to disable automatic filtering on visuals
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
- Anonymous9 years ago
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,
5 Replies
- AnonymousNot applicable
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,- hidenseek9
Post Patron
Anonymous
Thank you for your advice!
It is working perfectly.
Many thanks,
H
- JimT99
Helper I
I tried this with a card and it didn't work. When I click on the card it filtersr the rest of the visuals
- AnonymousNot applicable
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
- kwestRegular Visitor
Yes, it is under Settings and Options>Options>Query Reduction. This video shows where to find it: https://www.youtube.com/watch?v=ZEWr8wYsF5Y