Using slicer to view different data on the same visual

[Anonymous]

Hi,
Hope you're doing well. I have some data on the number of downoads, downloaders, seats provided, seats assigned for a software/app. I have loaded a few tables and created a visual showing "top 10 downloaders". I need to do the same "top 10" for downloads, seats assigned, provided, etc. Is there a way to create a slicer to select which top 10 data i want to see? Looking forward to hearing from you. 
Thanking you,
teckchan

[TeigeGao · Accepted solution]

Hi @Anonymous ,

In your scenario, we can create a table with the top 10 items of each dataset and the dataset name:

Assume we have two sets of data:

Then we can create a calculated table like below:

Table =
UNION (
    ADDCOLUMNS (
        TOPN ( 10, 'seats provided', 'seats provided'[number], ASC ),
        "count item", "seats provided"
    ),
    ADDCOLUMNS (
        TOPN ( 10, 'downloads', 'downloads'[number], ASC ),
        "count item", "downloads"
    )
)

Then use the "count item" as the slicer, use other field as the visual, the result will like below:

Best Regards,

Teige