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
Highlighted
Super User III
Super User III

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


Regards

Miguel Felix


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 III
Super User III

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

Regards

Miguel Felix


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? 

Highlighted
Super User III
Super User III

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


Regards

Miguel Felix


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

Proud to be a Datanaut!




View solution in original post

belvoir Member
Member

Re: line chart categorical x axis - showing a target

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors