Reproducing pivotchart in Power BI

[Marvinnv]

Hello,

I would like to reproduce the Pivotchart below in PowerBI:

Relevant pivottable:

Does anyone know how to achieve the above in PowerBI?

I've used Charticulator and the Multiple Axis Charts but I can't reproduce the above.

[negi007]

@Marvinnv it is easy in powerbi

[Marvinnv]

Hi @negi007 ,

I would need something similar to yours but when with one extra category like in my Excel example.

So basically I would like PowerBI to display two categories at the same time instead of only one.

[negi007 · Accepted solution]

@Marvinnv 

you can have as many categories you wish to have like below

[Marvinnv]

@negi007  Thank you for that!

However, when I add multiple categories as in the screenshot below only one category is visible on the Y-axis. Do you know what is causing this?

[mh2587]

You can use 100% stacked Bar chart for this

[Marvinnv]

Hi @mh2587 ,

When I try this I get the two views below (after drilling down).

However, I would like the data to be summarized as per below:

So basically displaying two categories at once instead of displaying one category at the time.

[mh2587]

Yup you have to drill down for further categories But you have achieve this by using slicer and just put the measure in the value