Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with Top N Filter

Hi everyone,

 

I'm having troubles with Top N filter, imagine you have this:

 

So I put "item" with Top 3 using "Qty" the variable by which to filter by, but this only works for all the serie. If I filter Store B the Top 3 of it would be 0. ¿What can I do?

 

Thanks

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    You can use "Top N" in visual filter and create a slicer based on column store as below:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous ,

     

    You can use "Top N" in visual filter and create a slicer based on column store as below:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.