Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
RoaaR
Regular Visitor

Default Tooltips (Know the formula or dax query behind it)

Dears,

 

Is there a way where I can find the formula behind a default tooltip value. I want to show the same value in another visualization but I don't know what's the dax query behind it to write.

 

Thanks

1 ACCEPTED SOLUTION

@RoaaR Ah, it's a percent of total. Well, couple things to try. Otherwise I'll need to know more about your data, whether that Market Saving % is a measure, etc. But, let's say that is a measure, you can often click the little down arrow next to the measure in the field well of a visual and click Show As and then Percent of Total or Percent of Grand Total, etc. That would be the first thing I would try. Otherwise, you need to do something along the lines of:

Percent of Total
  VAR __Measure = [Market Saving %] //assuming this is a measure
  VAR __Table = SUMMARIZE(ALL('Table'),[Category],"__Measure",[Market Saving %])
  VAR __Total = SUMX(__Table,[__Measure])
RETURN
  DIVIDE(__Measure, __Total, 0)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@RoaaR Can you provide an example (image). Most tooltip values are simple aggregations like SUM, MAX, MIN, etc.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thank Greg, 

Below is an example: the tooltip is showing the weight of percentage calculated on an aggrigation level:

This (79%) value shown in tooltip  is what I want to reach for different visuals & categorizatin

RoaaR_1-1664712984011.png

 

@RoaaR Ah, it's a percent of total. Well, couple things to try. Otherwise I'll need to know more about your data, whether that Market Saving % is a measure, etc. But, let's say that is a measure, you can often click the little down arrow next to the measure in the field well of a visual and click Show As and then Percent of Total or Percent of Grand Total, etc. That would be the first thing I would try. Otherwise, you need to do something along the lines of:

Percent of Total
  VAR __Measure = [Market Saving %] //assuming this is a measure
  VAR __Table = SUMMARIZE(ALL('Table'),[Category],"__Measure",[Market Saving %])
  VAR __Total = SUMX(__Table,[__Measure])
RETURN
  DIVIDE(__Measure, __Total, 0)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors