Forum Discussion

DFC's avatar
DFC
Frequent Visitor
6 years ago

Tooltip in Line and Clustered Column Chart

Hello everyone,   I am relatively new to Power BI. I was asked to have a tooltip for the bars and another one for the line. I looked around and the best I found was creating a report page of the ty...
Need Help
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi DFC ,

 

Sorry for that, But we cannot understand your data model clearly, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to One Drive and share the link here.

Please don't contain any Confidential Information or Real data in your reply.


Best regards,

 

DFC's avatar
DFC
Frequent Visitor
6 years ago

The school example I gave is just something I came up with that best resembles what I actually have to work with.

 

Here is the link to the mockup report itself: School Complaints Report 

 

Basically I have this tooltip as default.

 

 

 

 

 

 

 

 

 

If you've seen the data, it makes no sense to have the Place specified in the bar's tooltip since they aggregate all places. In the tooltip, where it would make sense to have it specified, it doesn´t show...

 

 

 

 

I have searched a bit more thoroughly and found this post from 2017 that asks essentially the same question

https://community.powerbi.com/t5/Desktop/Line-and-Clustered-Column-Chart-How-to-add-tool-tip-on-line/td-p/158480

 

They have since submitted the suggestion but I dont think it has been implemented yet.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34579048-combo-charts-how-to-add-tooltip-on-line

 

 

 

Side note: your posting box (the place where I´m writting right now) is terrible. The way ones inserts images feels archaic, the finished message (the one that gets seen by everyone) is rather different from what I see as I am writting (the paragraphs and spacing for example)... The whole aspect of it feels old and outdated and doesn´t really make me want to post here all that often tbh.

 

 

Cheers

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi DFC ,

     

    Thank you for your additional information, the default tooltips field does not show in the line chart is a issue we have reported in January 2020, the ETA of fix  is approximately mid April. Currently we can use a custom tooltips page as a workaround.

     

    Please refer to this thread (Reply 3 - 5) about this issue: https://community.powerbi.com/t5/Desktop/Tooltip-for-value-to-0-in-any-visuals/m-p/906118

     


    Best regards,

     

     

    • DFC's avatar
      DFC
      Frequent Visitor
      6 years ago

      As I mentioned earlier,

      "and the best I found was creating a report page of the type tooltip and associating it to the graph customization options"

      I tried custom tooltips but they were not a vlid solution. If I force all tooltips on that graph to show "First Place", it will be present on the bars and showing "First Place" there makes no sense.

       

      I'll wait for the April update to see if the problem is solved or if there's another workaround introduced.