Forum Discussion
dynamic target stacked bar chart
hi,
i am trying to make a stacked bar char with a dynamic target line, like the result using constant line but using a measure to determine the value, 8 changes every month. (custom visual bullet chart is not an opcion)
or some tutorial to make custom visuals.
thnks
h, Icey
not yet,
I gave myself my own solution, using a stacked bar char on value i put the value and the target, then the color of the target changes to withe and the data label target insade base, then play with the end of the x axis to bar width.
6 Replies
- amitchandak
Super User
Is the line and stacked chart is not serving the purpose
?
https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/
- Icey
Community Support
- santiagomur
Resolver II
h, Icey
not yet,
I gave myself my own solution, using a stacked bar char on value i put the value and the target, then the color of the target changes to withe and the data label target insade base, then play with the end of the x axis to bar width.- ammeijs
Helper I
santiagomur I cannot follow your solution. Can you collaborate/explain a bit more?
- Icey
Community Support
Hi santiagomur ,
First of all, glad to hear that you have found one workaround. Please accept your reply as one solution. Your contribution is highly appreciated.
Then, please check whether Bullet Chart by OKViz could also meet your requirements.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- RamyaRapoluFrequent Visitor
Hey ICIC ,
I have similar issue. Your solution is showing one bar for each category. Is it possible to stack all categories and add dynamic constant line like below?. Here my target line is derived using measure.