cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
belvoir Member
Member

line chart categorical x axis - showing a target

Hi all,

 

I'm looking to show a line as a target on a column chart - something like this which my client gave me:

 

 

Capture.JPG

 

 

 

 

 

 

 

 

 

The green line is the target percentage. I could use the clustered column chart but it doesn't emphasise the actual vs target sense of this visual. I found the Dumbbell custom visual - but it seems broken at the moment, and anyway doesn't seem quite right.

 

BTW, the X axis is categorical so a line chart won't do. Has anyone found something like this, or perhaps another visual that provide similar? None of the KPI visuals seems to provide a solution either. 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: line chart categorical x axis - showing a target

Hi @belvoir ,

 

I was assuming that you only wanted a single live for the first column, in this way you can do the following:

 

  • Options
  • Shapes
  • Stroke with = 0
  • Show Marker = On
  • Marker Shape = -
  • Marker size = 20

It will give you the result below.

targets.png

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
Super User
Super User

Re: line chart categorical x axis - showing a target

Hi @ Belvoir,

You could use the bar and line chart combo. If you don't want the line to go over all columns of the chart you should use a measure to calculate your target and use it in the line.

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




belvoir Member
Member

Re: line chart categorical x axis - showing a target

Hi @MFelix 

 

That sounds interesting - I tried using a column and line chart combo. The column works for categorical items but the line doesn't as it joins up each point - so how would using a measure deliver a single and separate line for each categorical item on the x axis? 

Super User
Super User

Re: line chart categorical x axis - showing a target

Hi @belvoir ,

 

I was assuming that you only wanted a single live for the first column, in this way you can do the following:

 

  • Options
  • Shapes
  • Stroke with = 0
  • Show Marker = On
  • Marker Shape = -
  • Marker size = 20

It will give you the result below.

targets.png

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Highlighted
belvoir Member
Member

Re: line chart categorical x axis - showing a target

@MFelix - genius! Client is very happy. Smiley Happy

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 59 members 1,218 guests
Please welcome our newest community members: