A simple gauge question

[#1]

I have built a gauge that is displaying some information from an SQL DB. Gauge looks good so far but I want the total # to live under the needle but I am not seeing how to make it display that. This is my first question on the community!

[Anonymous]

You can use "Text in Chart", where text is the same expression as for the chart itself.  You can move tis text in any place in the chart by using CTR+SHIFT and drag.

[#3]

What Total?

I think in your case you want to display 180?

Vinay

[Anonymous]

Please use text in chart in presentation tab:

[#5]

You can use "Text in Chart", where text is the same expression as for the chart itself.  You can move tis text in any place in the chart by using CTR+SHIFT and drag. (you need to "Reset User Sizing" & "Reset user Docking" first)

check above image

[#6]

Thanks Nitha P. Can you paste the text from Max and Text in chart? I am trying some of the other suggestions as well.

[#7]

Can you show me what you have in chart text to get the # to display? Thanks.

[Anonymous · Accepted solution]

Textbox value : =num(sum([Calls.Total Calls])/sum([Calls.Working Day]),'#,##0.0')

Max textbox value : max({1}[Calls.Total Calls])

Hope it helps

[#9]

It depend on your data but you can use something like...

sum({<Team={Team1}>}[Net Sales])

or

sum(Sales)

sum(qty)

Vinay

[#10]

Hi Mikel,

in oder to add the total value of the KPI you should add the expression (with the function for number formatting) in the section Text in Chart of the Presentation tab (as the 1st image attached), then you can resize or move the label clicking on it through the command Ctrl+Shift (and you can see the red borders as the 2nd image shows).