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 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
- amitchandakSuper User
larrylob , Image missing
- larrylobRegular Visitor
Sorry, posting issue. Just reposted. Thanks
- amitchandakSuper User
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.