Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have added a top N filter to mymuticard. On selection of another visual/button, the filter resets to 'all.' Is there any method to change this?
Note: I want interractions between visuals to affect the displayed value in the mutlicard(without resetting the filter)
Thank you
Solved! Go to Solution.
Hi, @FebaVar
It's not a reset, your filter is just applied to the current visual. When you put a field into Filters on this visual, the filter is only valid for the current visual.
When you select another visual, its filter is completely new and needs to be set for it.
If you want the top N filters for all visuals, you might as well create a measure. Like this:
Top5Values =
CALCULATE(
SUM('Table'[Hours by Year]),
TOPN(5, 'Table', 'Table'[Hours by Year], DESC)
)
Then put him into the individual visuals
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @FebaVar
It's not a reset, your filter is just applied to the current visual. When you put a field into Filters on this visual, the filter is only valid for the current visual.
When you select another visual, its filter is completely new and needs to be set for it.
If you want the top N filters for all visuals, you might as well create a measure. Like this:
Top5Values =
CALCULATE(
SUM('Table'[Hours by Year]),
TOPN(5, 'Table', 'Table'[Hours by Year], DESC)
)
Then put him into the individual visuals
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |