Build a grouped histogramm with multiple column as x

[pdhuicq]

Hello everybody,

In my company, we have a tool to follow the work of each worker. This tool generates workorders (WO). For each one, we have a creation date and a closure date.

The creation date is a field (named workorder.creationdate) of the WO, we can use it as is. the closure date is a formula : if the status of the WO is 30-ENDED or 40-CANCELED, then the date is the status date (field workorder.statusdate) ; the field is left blank in any other case.

I want to create a grouped histogramm to display the number of new WO each mounth and the number of closed WO each mounth. I know how to do each graph separately but I would like to do just one graph with both informations.

Any ideas how to do that ?

Thanks a lot in advance

[pdhuicq]

Hello,

My problem is not to show both information in y-axis, but to choose or build an information to put in x-axis.

Let assume I put closure date in x-axis, then I got what I whant to see for the closure diagramm, but absolutely not for opening diagram because they are exactly the same. In fact, when a closure date exists, a creation date exists too, and they are both displayed in the same date, the closure date. 

If I change x-axis to creation date, the same phenomenon occurs but with slightly differences, because sometimes a WO has a closure date, sometime no.

I want to share some data with you to help you make tests but I don't see it right now. I'll search more and post the file later.

Edit : Here is the link of a sample data file : https://we.tl/t-6yfUz0pKUD

[Anonymous]

Hi @pdhuicq ,

You can select the column chart in the visual object, and then put the creation date field and the closing date formula into the y-axis to display two data at the same time (as shown in the figure below). For more information about column charts in Power Bi, please refer to the documentation:Visualization types in Power BI - Power BI | Microsoft Learn.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.