topic Re: merged columns as slicers in DAX Commands and Tips

merged columns as slicers

Anonymous — Thu, 14 Mar 2024 08:08:47 GMT

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.

Re: merged columns as slicers

Anonymous — Thu, 14 Mar 2024 08:10:11 GMT

qqqqqwwwweeerrr

Re: merged columns as slicers

qqqqqwwwweeerrr — Thu, 14 Mar 2024 11:18:15 GMT

Hi Anonymous

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

Regards

Re: merged columns as slicers

Anonymous — Fri, 15 Mar 2024 06:42:17 GMT

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

Re: merged columns as slicers

qqqqqwwwweeerrr — Fri, 15 Mar 2024 06:53:03 GMT

Hi Anonymous

can you share you power bi data table snap,

regards