Dynamic columns in a Table Visual by slicer selection in Power BI

[Anonymous]

I have 3 slicers Region, Division, Sub division which are in hierarchical order as 'Region' being the top level granularity.

Hierarchy : Region - division - Sub division

I would want to change the column in my table visual dynamically based on the slicer selection.

•  When I select 'REGION' in slicer, my table visual should show data at  'Division' Level which is next level to 'REGION' as shown below

  

• When I select 'Division' in slicer,  my table visual should show data at 'Sub Division'  level which is next level granularity.

Regards,

Deepthi

[v-xicai]

Hi @Anonymous ,

You may try to create bookmarks for every selected options, for references: Use bookmarks to share insights and build stories in Power BI , Dynamic Visuals using Buttons.

Best Regards,

Amy 

Community Support Team _ Amy

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

[Anonymous]

Hi @v-xicai,

I appreaciate your support.

I cannot use buttons and bookmarks concept here as I have too many divisions and sub divisions. I have to switch between Division and Sub division in my table based on my slicer selection.

Thanks & Regards,

Deepthi

[AllisonKennedy]

I believe this is one of those 'where there's a will there's a way' scenarios, but can't think of a method that will be straightforward.

Is your current data model in one table or many tables?