Line Graph - How Do I Create a label from a different value?

[flyingmada]

I have a forecast line graph showing values based on a recorded date - and then that line graph goes to zero. I'd like to label the "0" value with the date. Is this possible in power bi?

Esiting graph is below. At the end of each line, I'd like the label to show as the date. Right now its only showing in the popup tool tip.

[Anonymous]

@flyingmada 

Unfortunately, using the tooltip is the only opinion. You can use format sting to show "date" when it goes to 0 but only in text data type. In your case, the measure has to be integer format in a line graph.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[parry2k]

@flyingmada there is nothing out of box but you can achieve this with format string in the calculation groups where you can put the condition that if value is zero then show date else show value.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡