The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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,
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
@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,
I tried this with a card and it didn't work. When I click on the card it filtersr the rest of the visuals
User | Count |
---|---|
109 | |
82 | |
74 | |
53 | |
49 |
User | Count |
---|---|
133 | |
97 | |
94 | |
71 | |
69 |