Forum Discussion

Jazlynnn64's avatar
Jazlynnn64
New Member
3 years ago
Solved

Power Bi slicers

Hi everyone,    I'm trying to create a clustered bar chart with slicers showing cell numbers just like the one I created in excel. I added the slicer and added the months to the x axis, and tried t...
Need Help
Show and Tell
Tutorial Requests
  • danextian's avatar
    danextian
    3 years ago

    Hi Jazlynnn64 ,

     

    Are the column names the cell numbers? If so, you need to transform your data so the cell numbers are in one column and the values in another.  Your data should look something like below through Unpivot

    Here's a tutorial on how to unpivot

    https://databear.com/power-bi-pivot-and-unpivot-columns/ 

     

    After unpivoting, you can use the attribute column in a slicer and as a category/legend.

     

Jazlynnn64's avatar
Jazlynnn64
New Member
3 years ago

Oops! I meant to add a picture of my data! 

 

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    3 years ago

    Hi Jazlynnn64 ,

     

    Are the column names the cell numbers? If so, you need to transform your data so the cell numbers are in one column and the values in another.  Your data should look something like below through Unpivot

    Here's a tutorial on how to unpivot

    https://databear.com/power-bi-pivot-and-unpivot-columns/ 

     

    After unpivoting, you can use the attribute column in a slicer and as a category/legend.