merged columns as slicers

[MorningStar_92]

here as we can see we have period-wise week data (ex. p2-w1 is period 2 week 1) , and its same for both the person i.e Emilia and michelle. moreover we can see active stores and sales data of each week of that period.

(** so basically we have same week and period's data but for 2 people **).

i want to create a slicer as emilia and michelle...... i.e: we will use a bar graph or whichever vizualization which shows the P2-w1,p2-w2.....p3w4 data with slicer having emilia and michelle so that when i select emilia the visualization should show the data of emilia only. 

i'm stuck on this for 2 days pls help. 

[MorningStar_92]

@qqqqqwwwweeerrr

[qqqqqwwwweeerrr]

Hi @MorningStar_92 

you can unpivot data in edit query that will slove your problem.

Regards

[MorningStar_92]

not helping us brother...anything else 

i mean as pbi works on columns so i just want that as soon as i click emilia it should show data of 1st 6 columns only which belongs to emilia only 

[qqqqqwwwweeerrr]

Hi @MorningStar_92 

can you share you power bi data table snap, 

regards