Showing a tooltop on line chart with multiple values

[dtartaglia]

Hi,

In the below chart, one Tool is selected (Adobe Photoshop) and I can display the tooltip using: ToolTipToolName = VALUES(SurveyDataTransposed[Tool]) as a Measure:

If multiple tools are selected, this causes an error:

Is there a way to show the tooltip for each tool in each column?

Thanks,

Dan

[Eric_Zhang · Accepted solution]

@dtartaglia

The error messages is quite straightforward, to get a scalar value, check below measure.

ToolTipToolName =
CONCATENATEX (
    VALUES ( SurveyDataTransposed[Tool] ),
    SurveyDataTransposed[Tool],
    ","
)

[dtartaglia]

Hi Eric,

Thanks for the response. I know some database and new to BI and DAX. Still feeling my way around.

[konstantinos]

@dtartaglia  Check out these posts:

 @Technitrain Chris Wedd https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/

 @SQLDusty  Dustin Ryan  https://sqldusty.com/2016/06/29/5-more-power-bi-tips/