Forum Discussion

PhilippMer's avatar
PhilippMer
Frequent Visitor
4 years ago
Solved

Tooltip on linecharts

Hello,  I am trying to re-do a colleagues Dashboard. I have created a line chart, with > 10 lines showing. When creating a Tool tip, everything works fine, but it showes me all Information for every...
  • Pragati11's avatar
    Pragati11
    4 years ago

    Hi PhilippMer ,

     

    Thanks for sharing the pbix file with me.

    I checked the pbix file and was not able to identify why this is not working as the tooltip and your chart looks perfectly fine.

    To check further, I thought why not try replicate this tab step-by-step to see where things are going wrong.

    I created a new tab, Then replicated the same line chart and set-up the tooltip on it and it seems to work:

     

    Now I added the slicers one-by-one like on your original tab. I started with DATE slicer and it works:

    I added the 2nd slicer for the views count and it still semms to work:

    As soon as I add the slicer for Post Type, the tooltip doesn't work anymore:

    One reason for this is:

    Post type come from LinkedIn logs table, which has MANY-to-ONE relationship with LinkedIn Post tables from where the Post Text is coming. Basically for one Post Text value, you can have multiple Post Type values.

    As soon as you select something in Post Type the tooltip gets filtered for only the selected Post Type value and shows all the Post Titles that have the selected Post Type values in the data. This makes sense to me.

    So this is how why you see such behaviour on your tooltip.

     

    One solution what I can suggest here is - Rather than moving Post Title to your legend section in Line chart, if you move Post Type in the legend section then this gives a better visibility on the information on the tooltip. Something like below:

    Once you start selecting the post type slicer, you see that the tooltip shows all the post titles that have this post type in the tooltip:

    So, based on the granularities you have in data this makes more sense to me. But this your data and you have better understanding of the usecase from business point of view on what is required here better than me.

    Let me know if this works or there is a different usecase that you need to replicate here.

    Apologies for coming back little late on this and such a long explanation, as I could not have explained it better than this.