Switch Function for Column Titles/Contents

[Anonymous]

Hello,

I'm looking for a formula for a measure that will only display the column headers and once the column header is selected the contents of the column appear in another chart.

Example:

Creating a slicer that has "Brand", "Manufacturer", "Category" - Each of these are columns within the database

Let's Assume I select Brand - I would like my treemap visualization to show the different brands and if I selected manufactuer I would like my treemap to change to manufacturers

I have individual columns that all have contents (Brand A, Brand B, etc) and I also have a column that has all of the column headers (Brand, Category,etc) - something to reference too? 

I can make the treemap based off of Sales values.

This data set is very restrictive and I can only create measures - No tables,etc... I've used the VAR function and Switch function previously to reference different measures.

Any help would be greatly appreciated

[Bian]

Not really sure how your data ooks like from your description but have you tried using Selectedvalue() to filter your other chart?

https://docs.microsoft.com/en-us/dax/selectedvalue-function

[Anonymous]

Yes I'm not really sure how to get the treemap to dynamically change based off of that formula... Any examples or help you could provide would be greatly appreciated.