Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a requirement to show values in Millions in the Data labels as well as the tooltip of a bar chart.
Setting it to Millions in the Display units dropdown only works for the Data labels not for the values in the tooltip.
I also tried using FORMAT function in my dax expression to change the value to Millions. However, it doesn't work at all. It makes my chart go blank.
Please help.
Thanks & Regards
Simran Tuli
Solved! Go to Solution.
@simrantuli - OK, I tried a couple different ways but couldn't get it. I'm thinking you do this, if "Measure" is your original measure, maybe:
Tooltip Measure = [Measure]/1000000 & "M"
You could use that in your Tooltip. Downside, original value will still be displayed as well.
Hi @simrantuli ,
You could use Format() to custom tooltip
tooltip =
FORMAT ( SUM ( 'Table'[Cost] ) / 1000000, "#M" )
My visualization looks like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @simrantuli ,
You could use Format() to custom tooltip
tooltip =
FORMAT ( SUM ( 'Table'[Cost] ) / 1000000, "#M" )
My visualization looks like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
@simrantuli - Perhaps try custom format strings as in Chelsie Eiden's Duration - https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Hi @Greg_Deckler ,
Could you please elaborate a bit on how can I use this approach mentioned in the blog that you shared to show values in millions (including the tooltip).
Thanks a lot for your help!
@simrantuli - OK, I tried a couple different ways but couldn't get it. I'm thinking you do this, if "Measure" is your original measure, maybe:
Tooltip Measure = [Measure]/1000000 & "M"
You could use that in your Tooltip. Downside, original value will still be displayed as well.
@hi @simrantuli - I was able to implement the solution using the approach mentioned by @Greg_Deckler.
See screen grab below for the same.
Please provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
@simrantuli Did you get an error or can you share a screen shot of the issue?
Sorry. I was making a mistake while creating the measure. Your solution works.
However, as you mentioned, the original value still gets displayed.
Best Regards
Simran Tuli
@simrantuli Glad you got it. Yeah, I don't know of a way to get rid of that default part of the tooltip. Only thing I can suggest would be to use a Tooltip Page but that might be overkill.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |