Forum Discussion
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...
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.
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