Set multiple target lines for a bar graph

Question

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!

jeremyking77 · Answer

Hi Benkee&nbsp;Maybe this a bit old now but you could utilise the Bullet chart to something like this&nbsp;&nbsp;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"&nbsp;&nbsp;&nbsp;

gilbertq · Answer

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

anonymous · Answer

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

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.

anonymous · Answer

Hi Anonymous,
&nbsp;
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.
&nbsp;
Regards,
Xiaoxin Sheng

anonymous · Answer

Try this&nbsp;https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380953?tab=Overview&nbsp;

Forum Discussion

Set multiple target lines for a bar graph

6 Replies

Related content

Multiple line and clustered columns chart

Target Line

Gauge visual with multiple targets

Target line

Target Line Based on What-If Parameter