Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer for columns

hello,    i have two numeric column field: VALUE & QUANTITY.   is it possible to combine them into 1 then will be used as slicer to switch them?          
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You may try the following formula to create a table:

    New table for slicer = 
var _t1=CROSSJOIN(SELECTCOLUMNS({"Quantity"},"Name",[Value]),  SELECTCOLUMNS('Table',"Value",[Quantity]))
var _t2=CROSSJOIN(SELECTCOLUMNS({"Value"},"Name",[Value]),SELECTCOLUMNS('Table',"Value",[Value]))
return UNION(_t1,_t2)

     

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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Anonymous Yes, you can unpivot your table in the Power Query and that will make your columns into rows and, you can use it for slicer.

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Value is actually a calculated column and Quantity is a natural column. so i could not see Value column in the Power Query