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.
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a 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.
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a Super User!
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
