Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
hidenseek9
Post Patron
Post Patron

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

 

2017-06-29 09_08_55-Promotion Analysis - Power BI Desktop.jpg

 

2017-06-29 09_16_10-Promotion Analysis - Power BI Desktop.jpg

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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.
1.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Anonymous
Not 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

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

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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.
1.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

JimT99_0-1651769707729.png

 

@v-yuezhe-msft

 

Thank you for your advice!

It is working perfectly.

 

Many thanks,

 

H

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.