Multi card visual filter resets on selection of another visual/button

[Anonymous]

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

[Anonymous · Accepted solution]

Hi, @Anonymous 

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.