Create an progress visual with due dates

[larrylob]

Hello,

I am trying to recreate a visual that is similar to one that was created in Excel. The visual uses dates of when different stages of document packages are due. Each package is a row in the table with 3 different dates in columns (see below).

Using this table we I am able to get a graph with the 3 different dates clustered together as can be seen below:

When I use the same data in Power BI to create a clustered ber chart, I am not able to use the acutal dates in the "Value" field. I am only able to use "Count of" when using the data and not get the dates on the X-axis like in Excel. The only visual I am able to get looks like the following:

I have tried many things like changing data type in Query Editor, using calculations, and using custom visuals and nothing is giving me the same graph. I'm not sure if it has something to do with the formatting of the data or limitations of the program. Any help would be greatly appreciated.

Thanks,

[amitchandak]

@larrylob , Image missing

[larrylob]

Sorry, posting issue. Just reposted. Thanks

[amitchandak]

@larrylob 

I do not remember some visual very similar to that. 

You can take date diff between the dates and plot those. Or take date diff from a date selected in the slicer and plot.

[larrylob]

Thanks for the advice. If I use the date diff wont this only plot the number of days between each date an not the actual date?

Thanks,

[Anonymous]

Hi @larrylob,

In my opinion, I'd like to suggest you create a table to expand records based on two date ranges that defined by three date fields and link with the raw table id field. Then you can use new table date fields and original table value filed to analyze across multiple date fields.

If you confused about coding formula, please provide some dummy data to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[larrylob]

Hello,

Sorry it took so long to answer but considering the issues going around the world right now I had other issues to deal with. 

A sample excel sheet can be found below. 

Lot	Construction date	Due Date for comments	Actual Date for comments	Due Date Final	Actual Date Final
FN01	2020-05-22	N/A	N/A	2020-05-29
FN02	2020-05-22	N/A	N/A	2020-06-05
RC05	2020-08-17	2020-06-10		2020-07-10
RS01	2020-08-14	2020-05-29		2020-06-29
RC02	2020-08-06	2020-05-20		2020-06-17
RC04	2020-06-16	2020-05-08		2020-06-08
RO04	2020-06-11	2020-04-29		2020-05-28
RE02	2020-06-11	2020-04-17		2020-05-15
RC01	2020-05-29	2020-03-27		2020-04-28
RO01	2020-05-21	2020-03-18		2020-04-17
RS02	2020-06-17	2020-03-06		2020-04-03
PO01	2020-01-07	2020-02-28		2020-03-27
RO02	2020-06-12	2020-02-26		2020-03-25
PC01	2019-11-27	2020-02-21		2020-03-20
RE01	2020-07-08	2020-02-14	2020-02-17	2020-03-13	2020-04-02
RC03	2020-06-16	2020-02-05	2020-02-05	2020-03-04
RO03	2020-05-04	2019-12-10	2019-12-19	2020-01-21

I'm not sure I follow you when you say to create a table to expand the records. 

Thanks for the help.

[Anonymous]

HI @larrylob,

You can do unpivot column on your date fields to convert them to attribute and value, then you can use Lot on axis, attribute on legend, value on value to create a graph.
Notice: current power bi does not support direct use date on value fields, they will be forced aggregate with count mode. Mabby you can check on appsource to find out custom visuals that allow you to use date value on value fields.

Regards,

Xiaoxin Sheng