Hide region district or territory based on Y or N slicer

[Euser]

Hello,

I have created 3 disconnected tables for Region District and Territory with Y/N slicer values.

Need to show Team and Brand names always.

If Region selected as Y show region else null. Same for district and territory. Need to hide or show region, district or territory based on Y or N slicer.

Please let me know is it possible to achieve this.

 

[rohit1991 · Accepted solution]

Hi @Euser ,
To dynamically show or hide the Region, District, and Territory fields based on slicer selections while always displaying Team and Brand, you can use disconnected slicer tables and DAX measures. You've already created three disconnected tables for Region, District, and Territory with Y/N options, which is a good starting point. The next step is to create measures that check the slicer selection and return the corresponding field value only if Y is selected. For example, for Region, create a measure that checks whether the selected slicer value is Y and, if so, returns the Region value from your main table; otherwise, it returns a blank. 

You can follow the same approach for District and Territory. Then, use these measures in your matrix visual instead of the raw fields. This way, when a user selects Y in a slicer, the corresponding field will be shown in the visual; if N is selected, it will be hidden (appear as blank), while the Team and Brand fields remain always visible.

[Euser]

Thanks for the reply.

Tried this method but measure will be used in value section so I am not able to show it as hierarchy in the same column as team and brand.

[v-bmanikante]

Hi @Euser ,

Could you please share the sample data along with expected result or a sample output you're aiming for? That would help a lot in providing a more accurate solution.

👉 Please make sure not to include any sensitive or confidential data in the sample

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Euser ,

Just checking in, has the issue been resolved? If yes, could you please share the steps that helped you fix it? It would be really helpful for other users who might face the same issue.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Euser ,

Just checking in, has the issue been resolved? If yes, could you please share the steps that helped you fix it? It would be really helpful for other users who might face the same issue.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Euser ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@Deku Thank you for your quick response.

As the Super User mentioned, please try using Field Parameters, as per my understanding, this approach should suit your requirement.

If it doesn't meet your expectations, kindly share a sample dataset along with the expected output (without any sensitive or confidential data), so we can help you more effectively.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[Deku]

You would need to use field parameters. Add a field parameter with all the columns. Then add columns for each of the slicer conditions, so you filter to leave just the columns you want to see in the matrix in each scenario

[Euser]

Hi, 

Thank you for your reply.

Have tried using field paramete and I need to select any onevalue like region or district or territory.

If I don't select the table showing all region district and territory.

Is there any solution for this.

Thanks