Dynamic Header

[Anonymous]

Hi everyone,

I have one Fact (left) and Dim (right) table each as the source in the screenshot below. These two tables have no relationship at all. 

In my dashboard, I will have two slicers: Options and Channel. When I select a value in Options (e.g. Channel1) slicer, the second slicer (Channel) should show the values in Channel1 (e.g. w, a, b, c).

Does anyone know how I can achieve that?

Thanks,

BK

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please review the following video and check whether that is what you want. It use UNPIVOT feature in Power Query Editor.

Power BI - Dynamic Columns in a Table

Best Regards

[manikumar34]

@Anonymous , 

if you are looking for a measure try somethingnlike this. 

measure =SWITCH( TRUE(),

SELECTEDVALUE(Tbale[Options]="Channel1",VALUES(Table1[Channel1]),

SELECTEDVALUE(Tbale[Options]="Channel2",VALUES(Table1[Channel2]),

SELECTEDVALUE(Tbale[Options]="Channel3",VALUES(Table1[Channel3]),BLANK())

Regards, 

Manikumar