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 res...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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

Hi Anonymous ,

 

This is the Pbix link: https://wetransfer.com/downloads/809d92c163452268d1f263adc804217120221013095358/ea2343a66070f801b194f7c551a822fb20221013095419/83b6ec

 

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

 

Thanks!!