Forum Discussion

BalazsNy's avatar
BalazsNy
Helper I
2 years ago
Solved

Bar chart with dates as values

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.

Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    2 years ago

    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.

5 Replies

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    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's avatar
      jlbriggs
      Regular Visitor
      10 months ago

      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.