Visualizing (Bar chart) two data points using two 2 date columns from the same table.

Anonymous — Sat, 24 Jul 2021 23:04:50 GMT

Hello,

Can you help me here?

I have 2 date columns (in the same table) and want to visualize 2 data fields as a Bar chart (side by side). see below screenshots.

Submision Date - Data field : Recieved projects

Completed Dates - Data Field: Delivered Projects

Thank you!

Re: Visualizing (Bar chart) two data points using two 2 date columns from the same table.

Fowmy — Sun, 25 Jul 2021 08:01:40 GMT

@Anonymous

Can you share the sample or dummy data for this chart?

Re: Visualizing (Bar chart) two data points using two 2 date columns from the same table.

Anonymous — Sun, 25 Jul 2021 22:17:35 GMT

@Fowmy

Provided data for this. I want to show barchart to show to count of Data values using two diffrent date columns. I want use month filter to show month wise data. Please let me know if you have any questions for me.

Thank you!

Data Values	Received Projects	Count of Completed Date	Completed Date	Submission Date
Data Collection	2	2	7/2/2021 0:00	6/30/2021 0:00
2D Creation (Fully Detailed Print Drawings)	1	1	6/25/2021 0:00	6/22/2021 0:00
Container Stuffing Validation (Cargo Wiz, Pack Assistant, Creo)	1	1	7/5/2021 0:00	6/11/2021 0:00
Data Collection	1			6/8/2021 0:00
Data Collection	1			6/23/2021 0:00
Data Collection	1	1	7/29/2021 0:00	6/23/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1			6/10/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1			6/11/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1			6/29/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1	1	6/7/2021 0:00	6/1/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1	1	6/16/2021 0:00	6/8/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1	1	6/24/2021 0:00	6/11/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1	1	6/25/2021 0:00	6/8/2021 0:00
Design (Returnable, Expandable - 3D model generation)	1	1	7/6/2021 0:00	6/11/2021 0:00
MPN Setup	1			6/30/2021 0:00
Others	1	1	6/25/2021 0:00	6/7/2021 0:00
Others	1	1	6/26/2021 0:00	6/7/2021 0:00
Others	1	1	7/6/2021 0:00	6/1/2021 0:00
Others	1	1	7/7/2021 0:00	6/8/2021 0:00
Packaging Solution (Multiple activities - Data Collection, Concept, FEA, Print Drawings, SWES Creation, etc)	1	1	6/11/2021 0:00	6/1/2021 0:00
Packaging Solution (Multiple activities - Data Collection, Concept, FEA, Print Drawings, SWES Creation, etc)	1	1	6/14/2021 0:00	6/4/2021 0:00
Packaging Work Order (Define, Collect, Validate, Update and Upload)	1			6/18/2021 0:00

Re: Visualizing (Bar chart) two data points using two 2 date columns from the same table.

V-lianl-msft — Wed, 28 Jul 2021 06:20:58 GMT

According to my test, this cannot be done. There cannot be multiple fields on the X axis. It is recommended that you create two charts and overlap them.

topic Visualizing (Bar chart) two data points using two 2 date columns from the same table. in Developer

Visualizing (Bar chart) two data points using two 2 date columns from the same table.

Re: Visualizing (Bar chart) two data points using two 2 date columns from the same table.

Re: Visualizing (Bar chart) two data points using two 2 date columns from the same table.

Re: Visualizing (Bar chart) two data points using two 2 date columns from the same table.