cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dunner2020
Post Prodigy
Post Prodigy

Vertical line in area chart

Hi there,

 

I am plotting some graphs on area chart. Area chart x-axis shows the month name. I have a measure that calculates the YTD value. I want to show that values as a vertical line in the area chart as shown in the figure:

 

Screenshot 2020-10-28 163355.jpg

If there is no mechanism then is there any other way of showing YTD value (that should stand out) in area chart? Thanks.

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @Dunner2020,

It sounds like you want to keep the raw graph and show the YTD line on your chart, right? 

Currently, you can't use multiple category fields on the legend field or use legend with multiple value fields at the same time.
I'd like to suggest you try to use line and clustered column chart which allows you to add an additional line to the raw graph.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@Dunner2020 , I doubt there is an option for a vertical line. What do mean by -"showing YTD value (that should stand out) "?

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

@amitchandak , If you look at the picture x-axis contains the month name. The orange line shows the value until the end of last month. I have created a measure that shows the value year-to-date. I want to show that value in such a way that it should stand out from other graphs. Is there any other way of doing that?

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors