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

Tooltip on chart with cumulative figures not showing correct data

Hi,

 

I am having some issue with creating a tooltip that shows cumulative sales broken down by groups.

 

I have a chart showing cumulative sales (all groups) by month/week, and that is working fine. I want to have a tooltip that shows a breakdown of the cumulative sales in groups.

 

Total Sales : $400,000 on chart

 

Tooltip to show :

Group A :$100,000

Group B: $150,000

Group C: $150,000

 

Is that possible? I assume it can be done as the default tooltip shows cumulatives sales for each date point but as a single figure.

 

I tried creating the tooltip with the Cumulative Net Sales measure as the value in the matrix, but it is only showing the sum of sales (by group) for that time period eg that week's data only, not cumulative.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Tooltip on chart with cumulative figures not showing correct data

@DarrenLau 

 

You may take a look at Create tooltips based on report pages.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
DarrenLau Regular Visitor
Regular Visitor

Re: Tooltip on chart with cumulative figures not showing correct data

Hi,

 

Bumping up the thread to see if there are workarounds or if I am missing something. Thank you.

Community Support Team
Community Support Team

Re: Tooltip on chart with cumulative figures not showing correct data

@DarrenLau 

 

You may take a look at Create tooltips based on report pages.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

cairesantos Visitor
Visitor

Re: Tooltip on chart with cumulative figures not showing correct data


@v-chuncz-msft wrote:

@DarrenLau 

 

You may take a look at Create tooltips based on report pages.


Hi @DarrenLau 

I bumped into the same issues and read the page recommended above.

Not sure If I missed something, but could not find the answer to this question.

 

Does it have something to do with the sentence highlighted below?

If so, it is rather unclear to me. Could someone explain?

 

Thank you!

 

Limitations and considerations

There are a few limitations and considerations for tooltips to keep in mind.

  • Beginning with the December 2018 release of Power BI Desktop, Button visuals also support tooltips.
  • Report tooltips are not supported for custom visuals.
  • Clusters are not currently supported as fields that can be shown in report tooltips.
  • When choosing a field to be shown for report tooltips, when using a field versus a category, visuals that contain that field will only show the specified tooltip when summarization with the selected field matches.

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,800)