How to show specific columns in a visual based on a filtered value

[taylorcurrier]

Hi all,

I'm not sure if this is possible, hoping someone can help. Below is a screenshot of what i'm working on - The top table shows an overall metrics for each section and when a user clicks on one of the line items, the table below is populated with the underlying details.  For instance, i have the following formula that allows the user to filter on any of the line items in the top table:

Check filter = If (ISFILTERED('Scorecard Output'[Product]),1, IF(ISfiltered('Scorecard Output'[Violation]),1, IF(ISFILTered('Scorecard Output'[Section]),1,0)))

(My company doesn't allow us to share data - hope this is illustrative enough)

I want the bottom table to show different columns based on what is selected in the top table, so that the user doesn't have to go searching and scrolling for the pertinent information.  Can this be done?

For example, I want each of the 11 second-level heirarchy items in the top table (Sequencing, Seasonality, Intraportfolio Cannibalization, etc.) to each show a different combination of columns, but not necessarily measures, in my underlying data. 

Thanks,

Taylor

[taylorcurrier]

@Greg_Deckler - thanks for the tip Greg, I've added more info to the original post!

[Greg_Deckler]

@taylorcurrier Can you provide a "for instance". In other words, what do you mena by "what is selected". Like the hierarchy level? A specific Section name, ?