Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Not applicable

Set multiple target lines for a bar graph

Hi all, instead of showing one Target Line for all categories, I would like to set one Target Line for every bar (category) in a bar chart, as example below. Every small line indicates the target sales for every Product. 
















Hopefully I can achieve that and show in my report. Thank you!



Not applicable

Hi @Anonymous 


Here is a bar chart with multiple target lines, which will help you to find the target and actual value differences.



Multiple Target lines for bar chart. PBIVizEdit.comMultiple Target lines for bar chart. PBIVizEdit.comMultiple Target lines for bar chart. PBIVizEdit.comMultiple Target lines for bar chart.



Download link for the custom visual file on this page, 



This was made with our Custom Visual creator tool With this tool,

  • anyone, irrespective of technical skills, can create their visuals
  • 15 minutes to create a visual from scratch
  • opens up many additional attributes to edit (e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problems/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in the editor).

Team PBIVizEdit


Frequent Visitor
Helper I
Helper I

Hi Benkee


Maybe this a bit old now but you could utilise the Bullet chart to something like this


bullet chart


You would need to add it from the PowerBI Marketplace (free)

The line values are the "Values" and the target lines are the "Target Value"




Super User
Super User

Could you not create one Target Measure and then use that measure in the visual?

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

Proud to be a Super User!

Power BI Blog

Not applicable

Hi, thank you for the reply. I believe that you are actually referring to this:image.png
















However, I am still hope that I can achieve the same result with the target lines as I might have many categories to show on x-axis.

Hi @Anonymous,


Current multiple category and multiple value field not compatible, you can choose one of them to use.
I'd like to suggest you post an idea about use multiple categories and values.



Xiaoxin Sheng

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

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.