Forum Discussion

YashPBI9154's avatar
YashPBI9154
New Member
4 years ago
Solved

Dynamic Top N multi-row card through slicer

Hi,

 

I have multi row card which provide counts of customer per country. Now i want to make it as dynamic through slicer.

 

for example if user select Top 10 from slicer then below provided card should showcase Top 10 country according to its customer counts.

 

Any help would be great.

Thanks

Yash Rastogi

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi YashPBI9154 ,

     

    Provide a method for your reference.

    Suppose we have a table like this.

    Create a new calculated column.

    Ranking = 
RANKX (
    ALLSELECTED ( 'Table'[Country] ),
    CALCULATE ( [Count of customers], ALLEXCEPT ( 'Table', 'Table'[Country] ) )
)

    Then create a new table.

    Table 2 = VALUES('Table'[Ranking])

    Enter data.

    Relationships.

    Note that the cross-filter detection between table 2 and table 3 should be set to both.

    Attached PBIX file for reference.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

2 Replies