Bar chart with dates as values

[BalazsNy]

Dear All,

I would like to convert an existing Excel chart into Power BI visual.

As shown below, this Excel chart is a clustered bar chart with record IDs as Y-axis & 2 different dates (actual & planned completition date) as values:

I have tried to get the same result with Clustered bar chart, but this visual in Power BI does not allow to display dates as values (only as count of dates). I have also thought about to display it on a Gantt chart, but these are only single dates without separate start & end dates.

Do you have any idea, how to get the same result in Power BI as in Excel?

Thanks for any tips in advance.

[MFelix · Accepted solution]

Hi @BalazsNy , 

You can use the new feature to get the labels to have details turn on:

I'm using a column called End Date so I get the Earliest value but you can also create a measure.

[jlbriggs]

Hi, I am confused how you got the "Earliest" option for your date field, as I can only get the "Count" option.
Is there some kind of setting on the column itself I need to change?
My column is set as a Date type.

[MFelix]

Hi @jlbriggs ,

If you are only getting the count is because you date column is formated has text and it will not get the latest value.

Check the data type for that column and if it is date.

[Ashish_Mathur]

Write this measure

Measure = min(Data[Date])

[BalazsNy]

Thank you very much @MFelix. It perfectly works.