Forum Discussion

superBro22's avatar
superBro22
Icon for Helper I rankHelper I
3 years ago

TopN & Others with multiple drill down

I have the following table:

 

And the folowing matrix visual and slicer:

Now , I need to add Vendor column to my matrix visual  as drill down but keeping my TopN order. This is the result I get and it is not correct because I am filtering top 3: 

 

 

 

I'd like a way to show only the Top N values and subvalues. For example: Show Top 1:

But I can not find a way to do so. 

 

Find attached the Pbix.  

https://wetransfer.com/downloads/809d92c163452268d1f263adc804217120221013095358/ea2343a66070f801b194f7c551a822fb20221013095419/83b6ec  

 

Can someone help me please?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi superBro22 ,

    I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_ Binbin Yu