Tracking hierarrchy/levels

[mb2207]

Hello, 

Is there a possibility to show in which level you are currently? And the same for a drill down in a hierarchy: is there an option for tracking in which hierarchy-level you are currently? 

I, as the creator of the reports, actually know which level follows next. But the receiver or user of the report who might not use it that often, might not remember all the levels/hierarchies.

I hope the problem/question is clear. Thank you!

Best regards,

Manuel

[amitchandak]

@mb2207 , You can check is in scope, But should use in reverse order

Category

-- Brand

-- Sub Category 

Then Check

Switch( True() ,

isinscope(Table[Sub Category ]) , "Sub Category",

isinscope(Table[Brand]) , "Brand",

isinscope(Table[Category ]) , "Category")