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 & ...
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.

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.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      10 months ago

      Write this measure

      Measure = min(Data[Date])

    • MFelix's avatar
      MFelix
      Super User
      10 months ago

      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.

  • BalazsNy's avatar
    BalazsNy
    Helper I
    2 years ago

    Thank you very much MFelix. It perfectly works.