Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a specific stacked column chart

Hello,

 

I am making dashboard for my internship and I don't know how to make a specific chart.

My datas are stocked in a table, in a similar way to this one.

 

 

And I have to recreate this table on Power BI.

 

So I need to get the Antimalware, Update Status, Online and Managed in four separate columns in Power BI. I tried to use the Stacked column chart and the 100% Stacked column chart, but without success in both cases. When trying to adjust the parameters, I end up with things like this or this (or others, but none of them as I would like.

 

If you have any idea on how to solve this and make it works, this would help me a lot ^^'>

If it is even possible to get what I'm trying to do, which I'm not sure...

 

Thank you !

Need Help
  • olgad's avatar
    olgad
    3 years ago

    Hi There,,
    i think you want something like this, 

    In Power Query Editor Select 4 columns you have and click unpivot columns

    After, create a stacked column chart and there you have it.

     

     

1 Reply

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    Hi There,,
    i think you want something like this, 

    In Power Query Editor Select 4 columns you have and click unpivot columns

    After, create a stacked column chart and there you have it.