Forum Discussion

svarghese's avatar
svarghese
Advocate I
9 years ago

Display labels for dates

Hi

 

I would like to plot labels(milestone names) against dates in powerBI like below.

I have the dates and corresponding milestones in a table . The below graph is from excel. Here Apple, Banana, Color, Joker etc are all milestones names for dates.

 


 

Any help is apreciated.

Thanks

Need Help

4 Replies

  • danextian's avatar
    danextian
    Super User
    9 years ago

    hi svarghese,

     

    Data labels in Power BI are dependent upon measures used.  You may format how the measures appear but showing as label other than the measure values is currently not possible. You may create measures  to be used as tooltips as an alternative  - they appear when hovering a data point in your visual - althought this may not be what you want. 

     

    The measure below will return concatenated texts from a column. 

     

    milestones =
CONCATENATEX ( VALUES ( [column] ), [column], ", " )

     

    • svarghese's avatar
      svarghese
      Advocate I
      9 years ago

      Thanks danextian. I would prefer to have somthig to be static on the graph and not only when hovering. The concatentae definetly seems like a good option for now. Would be better if I could actually have milestone dates marked like in the graph i had attached.