Forum Discussion
Custom tooltips in Line Chart Visuals Legend Issue
hello lkaneff
perhaps the mismatch result comes from not accurate measure?
here is a simple example of my dummy data.
When i create a measure for getting the value of ID, it will get wrong result.
to achive the right result, i made a column index, then i refered a measure to that index.
the important is you can not create a measure to get a value that is not a number so you need to repointing a number into that string value.
i am not sure if i explained correctly but hope you get the idea.
Hope this will help.
Thank you.hello lkaneff
that is depend on how your data is.
i did with indexing the column based on value for all data/rows. after indexing, i calculate which index has the max value on each date. then i calculate what country based on the return index.
but surely you can do with if statement to do this. in my experience, you can not rely on DAX to return a string value directly so you need a unique value for what you want to get then return that value into the string value.
take a note as mentioned by danextian , by default line chart will calculate across all lines.
Hope you get the idea.
Thank you.
hello lkaneff
did you use the custom tooltips suggested in the link?
i am not sure about custom visual tooltip but power bi custom tooltip depend on the calculation.
try checking this link
Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Thank you.
Yes. I've even tried measures. It doesn't work. My custom tooltip works fine in other chart types but if I do a line chart or area chart my locations do not change.
hello lkaneff
perhaps the mismatch result comes from not accurate measure?
here is a simple example of my dummy data.
When i create a measure for getting the value of ID, it will get wrong result.
to achive the right result, i made a column index, then i refered a measure to that index.
the important is you can not create a measure to get a value that is not a number so you need to repointing a number into that string value.
i am not sure if i explained correctly but hope you get the idea.
Hope this will help.
Thank you.Would you mind showing me the measure you used to get that to work. I'm a bit of a beginner. That is exactly what I want. I assume you did an if statement and then a text output. Am I on the right track? I can try it myself and if I can't figure it out I'll post again. Thanks for your help!
hello lkaneff
that is depend on how your data is.
i did with indexing the column based on value for all data/rows. after indexing, i calculate which index has the max value on each date. then i calculate what country based on the return index.
but surely you can do with if statement to do this. in my experience, you can not rely on DAX to return a string value directly so you need a unique value for what you want to get then return that value into the string value.
take a note as mentioned by danextian , by default line chart will calculate across all lines.
Hope you get the idea.
Thank you.