Forum Discussion
Helper Istacked and grouped histogram
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 !
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.
1 Reply
- ray_aramburo
Super User
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.