Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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)
@RoaaR Can you provide an example (image). Most tooltip values are simple aggregations like SUM, MAX, MIN, etc.
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 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)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |