Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @Anonymous
Here is a bar chart with multiple target lines, which will help you to find the target and actual value differences.
Download link for the custom visual file on this page,
https://pbivizedit.com/gallery/bar-chart-with-multiple-target-lines
This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,
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).
Thanks,
Team PBIVizEdit
Hi Benkee
Maybe this a bit old now but you could utilise the Bullet chart to something like this
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"
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.
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.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |