cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Line Chart Tooltips - Displaying too much data

Hi, I've creaed a Line Chart vizualization in a Power BI desktop file that works and looks exactly as intended, except the tooltips are displaying values for 4 categories, where I'd like them to just display the values for a single category at a time. 

 

See img below:

 

see the tooltip showing values for 4 categories for the selected monthsee the tooltip showing values for 4 categories for the selected month

I'd like the tooltip to look like it does when I've sliced just one category, see img below:

tool tip provides values for a single categorytool tip provides values for a single category

Any tips on how to acheive this would be much appreciated!  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Line Chart Tooltips - Displaying too much data

Hi @ianmonat,

 

If you want the tooltip shows one value, you can filter the category by slicer or visual level filter.

 

Currently, power bi desktops do not support manual select tooltips info, you can vote below idea:

Choose additional tooltip info

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Line Chart Tooltips - Displaying too much data

Hi @ianmonat,

 

If you want the tooltip shows one value, you can filter the category by slicer or visual level filter.

 

Currently, power bi desktops do not support manual select tooltips info, you can vote below idea:

Choose additional tooltip info

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

Re: Line Chart Tooltips - Displaying too much data

Cool ,

 

What u r viewing in that tooltips it exactly correct.

Because u have "Distibutor" in Legend know that is the reason to show all.

 

so it was showing correct,

 

If u want the tooltip like u mention in second visual , Use Distributor on slicer .

Highlighted
Super User IV
Super User IV

Re: Line Chart Tooltips - Displaying too much data

Hi @ianmonat, what you could do is to create a calculated measure, in which you calculate the MIN or the MAX value of your data being viewed. By doing this MIN or MAX, this will only return one value. 

 

You can then within your Calculated Measure put in some Text Values to give it the description you require.

 

Have a look at this blog post by Dustin Ryan explaining how he achived this.

 

https://sqldusty.com/2016/06/29/5-more-power-bi-tips/ - Then look under the Create a Calculated Measure to Display Descriptive Tooltips section.

 

And then finally you can put your Calculated Measure into the Tooltips area.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Helper I
Helper I

Re: Line Chart Tooltips - Displaying too much data

Thanks, I voted

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.