Forum Discussion

royces99's avatar
royces99
Frequent Visitor
2 years ago

Specify today as x-axis constant

I have a line and stacked column chart with date on the x axis (no hierarchies) and want to add a constant line representing today.  I have a measure for TODAY() but only seem to have the option of selecting a specific date rather than entering my measure as a field value.  How can I fix this?

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    royces99 , Create a measure

    Today = Today()

     

    Click on the Fx button use field value and choose the Meausre

  • royces99's avatar
    royces99
    Frequent Visitor
    2 years ago

    I have tried this but it doesn't work with the error below:

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi royces99 

     

    Unfortunately, Power BI does not allow the direct use of a DAX measure (like TODAY()) to dynamically set the value of a constant line in visuals directly.

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.