Line chart tooltip to show only one value (x,y) when hovered over the specific line data point.

[WKN]

I have a set of raw data with the following data columns that makes up a multiple line chart.

x-axis: Power on Time

y-axis: Measurement

Serial Number: SN

Data Grouping: Group

Line chart that plot all x, y data points were able to show tooltip data accurately when hovering over the data point. It is showing accurately the x, y values and its corresponding SN for every data point. However, if a slicer with Group is added to filter the line chart to show only 1 group of data, tooltip will show a different value than where the cursor is positioned. 

Is there a way to show the exact x,y value and its corresponding SN at the cursor location on the line chart? I have also tried dynamic / custom tooltip and this don't work either. 

Tooltip showing accurately the x, y datapoint value where the cursor is positioned when all data is plotted.

Tooltip not showing the actual x, y datapoint value where cursor is positioned when data is filtered to Group 1 in the dataset.

[VijayP]

@WKN  The tool tip is showing correctly! 

When you have not selected any slicer value it shows the average of all but when you select any specific slicer item

it shows the individual value.

If you want a better expereince , try creating Custom Tooltip and show case the info accordingly

https://www.youtube.com/watch?v=hamC5sYfsH8&list=PLWQB3PEUJKRn1Y_s8whVWEoPPZa6Wm8B6&index=4&pp=gAQBi...

[WKN]

Is there a way to show the exact x,y value and its corresponding SN at the cursor location on the line chart when only 1 group of data is selected from the slicer? Meaning not showing the average of all but the exact x,y value. 

[Anonymous]

Hi @WKN ,

I create a table as you mentioned.

Then I put it in the line chart.

When I use slicer, it will also show me tooltips.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WKN]

Hi, 
Thanks for your response and the attached file. I extended the data in your sample data to better replicate my dataset then updated the line chart. 

Number	Group	Thing	Time	Measurement
1	AA	A	58	20
2	AA	B	58	-20
3	AA	C	58	30
4	AA	A	43	40
5	AA	B	43	0
6	AA	C	43	60
7	AA	A	23	60
8	AA	B	23	40
9	AA	C	23	90
10	BB	D	67	10
11	BB	E	67	-10
12	BB	F	67	20
13	BB	D	65	30
14	BB	E	65	10
15	BB	F	65	40
16	BB	D	21	50
17	BB	E	21	40
18	BB	F	21	60

The tooltip will show the value of Time and list all Measurements for every Thing.

Is there a way to show only one Measurement when the cursor is hovering on just one Thing in the Line Chart?

Line chart tooltip list all Measurements when cursor is at Thing = C.

FYI I did not enter any parameters in the Tooltips section because then the tooltip appearance in the visual becomes very messy.

[Anonymous · Accepted solution]

Hi @WKN ,

I create the same visual as you mentioned.

I think you can create a calculated column and it will show you all about what you want to show. Here is the DAX code.

Column = 'Table'[Time] & + "+" &  'Table'[Thing] & + "+" & 'Table'[Measurement]

Since the other four values are present by default, they cannot be removed, but it is possible to create only one Measure or Calculated Column.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.