Show data (not measure) from different column based on selection

Hi luvnet18 ,

You could create a new table.

Divide the original table into three tables and append them using the union() function.

new table = 
var table1 = selectedcolumn('table',"customer",[customer],"promo tag1",[promo1_tag1],"promo tag2",[promo1_tag2],"promo unit",[promo1_unit],"promotype","promo1")
var table2 = selectedcolumn('table',"customer",[customer],"promo tag1",[promo2_tag1],"promo tag2",[promo2_tag2],"promo unit",[promo2_unit],"promotype","promo2")
var table1 = selectedcolumn('table',"customer",[customer],"promo tag1",[promo3_tag1],"promo tag2",[promo3_tag2],"promo unit",[promo3_unit],"promotype","promo3")
result
union(table1,table2,table3)

Then create a slicer table:

PromoType
Promo1
Promo2
Promo3

At last create a relationship between new table and slicer table by PromoType column.

Best Regards,

Jay