Using Column headers as slicer

[Anonymous]

The standard answer in the message boards is to unpivot specific columns, but if if I do that, the dataset baloons from a few thousand rows to a few hundred thousand rows because im trying to unpivot something like 30 columns. I havent quite cracked the sanddance 3d plot yet, but something like that could be an option also.

Backstory, i have an oil analysis database that has analysis date (my preferred x) and multiple partlcle columns (my y) of iron, glycol, etc. If I could use the column header as a button filter to toggle particles, it would be ideal.

My current state. plotting a single particle is easy enough, but I want to make the graph available to non-power bi savvy users, avoid the drag and drop, and preferably have a click from a dropdown as if it were an upivoted table.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could try to create a column header table like

Then create a measure with the SWITCH function.

Measure =
SWITCH (
    SELECTEDVALUE ( 'Table (2)'[Column Headers] ),
    "glycol", SUM ( 'Table'[glycol] ),
    "iron", SUM ( 'Table'[iron] ),
    "lead", SUM ( 'Table'[lead] ),
    "magnesium", SUM ( 'Table'[magnesium] )
)

Results:

You can download the attachment for more details.

Best Regards,

Stephen Tao

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

[Anonymous]

I have also created a reference table of particle that almost gets me to where I need to go by letting me click what are in effect column headers, I just can't plot more than one particle.