Gauge value not showing up as number

[Anonymous]

Hi,

I am having two columns with information:

Column A = Non-technical labour (hours)

Column B = Technical labour (hours)

Both fields are formatted as a "Whole Number" in Power Query Editor

({"Technical Labour (hours)", Int64.Type}, {"Non-technical labour (hours)", Int64.Type})

When I put both as Gauges in Power BI Desktop, "Non-technical labour (hours)" shows up as I want it - a simple number, "Technical Labour (hours)" shows up as a $ value (see below). 

I have checked and double checked all settings for both gauges in Power BI Desktop and have played with the type in Power Query Editor, but I cannot get "Technical Labour (hours)" to show up a simply a number.

Could anyone please tell me what I am doing wrong here? 

Thank you.

Robert

[Anonymous]

Sorry for the bad formatting. 

Somehow what I did in the browser did not come across.

Here also the photo again:

[Anonymous · Accepted solution]

Hi,

Found the answer to my own question. In Power BI Desktop on the "Modelling" tab, while Data Type was "Whole Number" for both fields, the format was "Currency General" for one and "Whole Number" for the other.

Boy that took long to figure out...

[v-joesh-msft]

Hi @Anonymous ,

It's pleasant that your problem has been solved, could you please mark the reply as Answered? that way, other community members will easily find the solution when they get the same issue.

Best Regards,

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