stacked and grouped histogram

[Aikeno]

Hello,

My goal is to have on Power BI an histogram with two column for every months.

The first one would be a column divided in 3 (exp manufacturer, exp customer, exp field) and next to it another column divided also in 3 with the "done" numbers.

Like on this picture but with "exp" and "done" separate.

Thanks for your help !

[ray_aramburo · Accepted solution]

1. Create a separate Catgory/Subcategory column where you only specify either Exp or Done. 

2. Unpivot your data to look like this:

3. Histograms are not a standard visual in Power BI, you can import them from the marketplace but unfortunately they aren't that good. For this reason, I'd suggest you to use a column stacked chart. It would look like this:

Note: I added a sort column to show months in the correct order.