Customization in Slicer

Hello All,

Let me explain the scenario;

I had to extract “Section” from URL through power query. The URL is in following format:

Domain name/country code/section/subsection/pagename.html

Extracting “Section” is not a big deal and it is done. Now they asked for the “Sub Section” and that is also not a big deal. But the requirement for Sub section is complicated. Management is looking for information about a particular sub section, not interested about others. Through power query I able to segregate that particular Sub Section and the Other Sub Sections will be marked as “N/A”.

But when in Filter I am trying to put the Section and Sub Section together it looks like:

1. Sec A

• N/A

1. Sec B

• N/A
• Sub Section

1. Sec C

• N/A

1. Sec D

• N/A
• Sub Section

1. Sec E

• N/A

Now I don’t want to show “N/A”, but I de-select the “N/A” from Sub Section option in Filter Panel – Sec A, Sec C & Sec E totally disappear, and “N/A” portion of Sec B and Sec D disappear.

My idea is to show the filter as:

1. Sec A
2. Sec B

• Sub Section

1. Sec C
2. Sec D

• Sub Section

1. Sec E

When the user selects Sec A to E the section data will show and when Sub Sections will be selected data will be customized as per that.

Is it something fishable? If yes, any suggestion?

Hope I am clear with my situation.

Regards

Utsav