Forum Discussion
Using a line chart with additional values
Hi all!
I'm building a line chart where I'd like to show, apart from the temporal evolution of a measure, a value in each points that represents any other information associated with that temporal reference.
For example, let's suppose I have two tables, one with Year and Amount:
| Year | Amount |
| 2020 | 200k |
| 2021 | 380k |
| 2022 | 180k |
And another one with Year and Deviation:
| Year | Deviation |
| 2020 | -5,3% |
| 2021 | 3,2% |
| 2022 | -7,9% |
What I'd like to know is if PowerBI line chart offers the feature to display a line representing the values of Amount and, also, a deviation as an additional info for each point, just like this:
In case this is not possible, does PowerBI offer any other chart that could fit to my needs?
Thanks in advance for your kind help.
Hi @sieed ,
Here is ToolTip Data Label Line Chart which will help you to see the value at all the Data Label on both lines. Hope this helps you.Line Chart with ToolTip for Data Label PBIVizEdit.comLine Chart with ToolTip for Data Label PBIVizEdit.com
Download link for the custom visual file in this page
https://pbivizedit.com/gallery/dual-axis-line-with-data-labelYoutube Link for the custom visual
https://www.youtube.com/watch?v=BFbL2AzKDZc
This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,- anyone, irrespective of technical skills, can create their own visuals
- 15 minutes to create a visual from scratch
- opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)
Give this a shot and let us know if you face any problem/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 editor).
Thanks,
Team PBIVizEdit
3 Replies
Hi @sieed ,
Here is ToolTip Data Label Line Chart which will help you to see the value at all the Data Label on both lines. Hope this helps you.Line Chart with ToolTip for Data Label PBIVizEdit.comLine Chart with ToolTip for Data Label PBIVizEdit.com
Download link for the custom visual file in this page
https://pbivizedit.com/gallery/dual-axis-line-with-data-labelYoutube Link for the custom visual
https://www.youtube.com/watch?v=BFbL2AzKDZc
This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,- anyone, irrespective of technical skills, can create their own visuals
- 15 minutes to create a visual from scratch
- opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)
Give this a shot and let us know if you face any problem/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 editor).
Thanks,
Team PBIVizEditLook for line chart visuals that support a second Y axis. Or create your own in Charticulator or other tools.
hi
You can use infographic designer visual. Add year , amount and deviation to your visual.make the chart type as line chart
add 2 text box in the infographic visual . with data binding assign amount and deviation to the respective text box.Place these text boxes above the dots in the line chart using the layout pane.
If this post helps, Accept it as a solution
