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

7 Replies

    • larrylob's avatar
      larrylob
      Regular Visitor

      Sorry, posting issue. Just reposted. Thanks

      • amitchandak's avatar
        amitchandak
        Super User

        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.