Using a line chart with additional values

[Anonymous]

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. 

[Mayank_Yavda · Accepted solution]

 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-label

Youtube 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

[Anonymous]

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

[lbendlin]

Look for line chart visuals that support a second Y axis. Or create your own in Charticulator or other tools.