Category & Subcategory & button approach

[PrakashPalle]

Hi All,

Is it possible to show in main page of the report? Below are the requirements.

1) Category is a slicer where user can select different categories.

2) For the selection of category respective subcategories need's to display as buttons like below.

3) Sub categories border need's to highlight based on the "High" or "No" conditons?

4) If we click on the subcategories button selection it should redirect as drill through action wise(I have only 3 pages to drill through the report, i cannot add multiple pages with the page navigation option)

Please suggest. Thanks in advance.

[Ritaf1983]

Hi @PrakashPalle 

It seems you need to use bookmarks with show/hide functionality.

Please refer to the linked tutorials :
https://www.youtube.com/watch?v=QUcW8gudhLw

https://www.youtube.com/watch?v=7DuNAgiyIQU

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

[PrakashPalle]

Thanks @Ritaf1983 for the reply.

I cannot go ahead and use the bookmarks feature, why because my subcategories column is not static it will increase the buttons future. It should work like a dynamic approach. I tried with a slicer, but there i am facing issue while giving the slicer border conditional formatting it is not working. Please help.

[Ritaf1983 · Accepted solution]

@PrakashPalle 
Unfortunately, I don't think that we have other options to get the desired interactivity.