Forum Discussion

larrylob's avatar
larrylob
Regular Visitor
6 years ago

Create an progress visual with due dates

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
larrylob
Regular Visitor
6 years ago

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. 

 

LotConstruction dateDue Date for commentsActual Date for commentsDue Date
Final		Actual Date
Final
FN012020-05-22N/AN/A2020-05-29 
FN022020-05-22N/AN/A2020-06-05 
RC052020-08-172020-06-10 2020-07-10 
RS012020-08-142020-05-29 2020-06-29 
RC022020-08-062020-05-20 2020-06-17 
RC042020-06-162020-05-08 2020-06-08 
RO042020-06-112020-04-29 2020-05-28 
RE022020-06-112020-04-17 2020-05-15 
RC012020-05-292020-03-27 2020-04-28 
RO012020-05-212020-03-18 2020-04-17 
RS022020-06-172020-03-06 2020-04-03 
PO012020-01-072020-02-28 2020-03-27 
RO022020-06-122020-02-26 2020-03-25 
PC012019-11-272020-02-21 2020-03-20 
RE012020-07-082020-02-142020-02-172020-03-132020-04-02
RC032020-06-162020-02-052020-02-052020-03-04 
RO032020-05-042019-12-102019-12-192020-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's avatar
    Anonymous
    Not applicable
    6 years ago

    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