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

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'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