Show sub cat on slicer selection

[Anonymous]

Hi Experts

is it possible within Power Bi to Select from a slicer a Product and based on that seletion show the sub categories assoicated with that product... i.e. See sceen shots below...

So if i select Banana from the slicer then show te sub cat associated with Banana and the data points too. Image 1

Start

End result

[rajulshah · Accepted solution]

Hello @Anonymous,

Try using custom visual, hierarchy slicer.

Following links may help you:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview

http://blog.pragmaticworks.com/power-bi-custom-visuals-hierarchy-slicer

Hope this helps.

[Anonymous]

Many Thanks

[rajulshah]

If this is the solution you wanted, please mark it as the solution so it can help others!

[Anonymous]

But can i do that in a table....not just in the slicer???

[rajulshah]

Hello @Anonymous,

I am afraid you cannot do it as you're expecting it to do it.