cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Trudgeon Regular Visitor
Regular Visitor

Line Chart Tooltips Issue

I'm getting redundant details on the tooltips of my line chart.  The salesperson name is showing up twice.  Once associated with the legend and once associated with the value.  Why is it doing this?  Is there a way to remove the "SALESPERSON" item from my tooltip?  It looks bad to have the person's name show up twice the way it does.

 

Thanks!

 

 

Format.PNG

 

Tooltips.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Line Chart Tooltips Issue

Hi @Trudgeon

When i add columns and measures to "Value" and "Tooltips" field and set the "Tooltip" as "Default", it shows the same as you.

1.png

 

As tested and reseraching, i'm afraid it is the default design in Power BI currently.

you may add your idea here to let more people know and vate for your idea, finally it may be accepted by Product team.

 

As a workaround, i change the Tooltip setting  from "Default" to "Report Page".

I try two methods.

One is to use Card visual and Text Box, also create new measures to show each person's value.

 

create measures

Michael = "Michael"

value-John = CALCULATE(SUM(Sheet6[kg]),FILTER(Sheet6,[salesperson]="John"))
tootip-John = CALCULATE([kgs],FILTER(Sheet6,[salesperson]="John"))

value-Michael = IF(CALCULATE(SUM(Sheet6[kg]),FILTER(Sheet6,[salesperson]="Michael"))<>BLANK(),
CALCULATE(SUM(Sheet6[kg]),FILTER(Sheet6,[salesperson]="Michael")),0)

tootip-Michael = IF([value-Michael]=0,0,CALCULATE([kgs],FILTER(Sheet6,[salesperson]="Michael")))

in another page, called Page3, add [date] column, these measures in the Card visual, also create two Text Box and write "KGS SOLD" in it.

Then set this page as "Tooltip" by turning on "tooltip" button under the Page information and selecting "tooltip" under Page size.

for the Line chart, select "Report Page"-> Page3.

 

2.png

 

The second method please see my pbix->Page2

Reference: Report tooltip

 

 

Best Regards

Maggie

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Line Chart Tooltips Issue

Hi @Trudgeon

When i add columns and measures to "Value" and "Tooltips" field and set the "Tooltip" as "Default", it shows the same as you.

1.png

 

As tested and reseraching, i'm afraid it is the default design in Power BI currently.

you may add your idea here to let more people know and vate for your idea, finally it may be accepted by Product team.

 

As a workaround, i change the Tooltip setting  from "Default" to "Report Page".

I try two methods.

One is to use Card visual and Text Box, also create new measures to show each person's value.

 

create measures

Michael = "Michael"

value-John = CALCULATE(SUM(Sheet6[kg]),FILTER(Sheet6,[salesperson]="John"))
tootip-John = CALCULATE([kgs],FILTER(Sheet6,[salesperson]="John"))

value-Michael = IF(CALCULATE(SUM(Sheet6[kg]),FILTER(Sheet6,[salesperson]="Michael"))<>BLANK(),
CALCULATE(SUM(Sheet6[kg]),FILTER(Sheet6,[salesperson]="Michael")),0)

tootip-Michael = IF([value-Michael]=0,0,CALCULATE([kgs],FILTER(Sheet6,[salesperson]="Michael")))

in another page, called Page3, add [date] column, these measures in the Card visual, also create two Text Box and write "KGS SOLD" in it.

Then set this page as "Tooltip" by turning on "tooltip" button under the Page information and selecting "tooltip" under Page size.

for the Line chart, select "Report Page"-> Page3.

 

2.png

 

The second method please see my pbix->Page2

Reference: Report tooltip

 

 

Best Regards

Maggie

 

Trudgeon Regular Visitor
Regular Visitor

Re: Line Chart Tooltips Issue

Thank you for the workarounds, @v-juanli-msft

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 201 members 2,728 guests
Please welcome our newest community members: