Can't change decimal in format

[BlackCat]

I am trying to change the decimal in one of my columns, I've highlighted that it should read 10,416.67 but instead as you can see in my attachment is reading $1,041.667. I've tried to change the decimal in the ribbon using format but it doesn't correct itself. Could it be my measurement, am I missing something in my calculation? Any help is greatly appreciated.

[parry2k]

@BlackCat Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

It is a measure issue, not a format issue. It is not clear what is sum duration in months is returning in your denominator. Can you put that in your visual to see what value sum of duration returns?

[Pragati11]

Hi @BlackCat ,

Is this what you are looking for:

[BlackCat]

It looks correct but should be displaying 10,416.67

[Pragati11 · Accepted solution]

Hi @BlackCat ,

It looks like you want to divide this value further by 100 to get that format. Is it right?

Something like below:

[BlackCat]

That worked!! TY!!!

[Pragati11]

Hi @BlackCat ,

As @parry2k  mentioned, it was not a decimal data-type format issue, the issue was with the measure.

You needed to divide your final value in the measure by 100 so that the displayed data format is to your requirement. The data-type format in power BI was correct from the starting.

Thanks,

Pragati

[BlackCat]

Yes correct it was a measurement issue, when divided by 100 it was corrected. With the middle visual, I cannot provide "Totals" for some reason this is also an issue, please see attached. Thank you in advance.

[Pragati11]

Hi @BlackCat ,

What do you mean by you couldn't provide totals? Can you please be more clear?

[BlackCat]

If you look at my last column subtotals they are returning the value of each column and not the total month over month. For instance The Division Learning should be totaling the entire row.

[Pragati11]

Hi @BlackCat ,

Turn on ROW SUBTOTALS as shown below:

[BlackCat]

I have turned that on, but it still does not total month over month, it returns the same value.

[Pragati11]

Hi @BlackCat ,

I think there is problem with your measure calculation. It shows same value for every month. See the screesnhot below as highlighted:

Check relationships between the tables from where the fields are moved in this visual.

[BlackCat]

This calculation is for "weighted"

Weighted contract/mo = DIVIDE('Deal'[weighted total contract],MAX('Deal'[Contract Duration in Months]))

It is a month over month but should be able to total at the end of the row or column, it does in my standard report

[Pragati11]

Hi @BlackCat ,

But I can't see your calculation chnaging month-wise in the matrix visual that you have created.

The reason is the MONTH-YEAR column in this visual comes from a different table which hasn't got any relationship with your DEAL table.

Check this at your end. You will understand what I am trying to say.

Also create a new thread for this issue just that it is easier for others to locate right solutions to the respective threads.

Tag me once you create a new thread.

[Pragati11]

Hi @BlackCat ,

This shouldn't be this hard. Something is really going wrong.

Can you share your pbix file ?

[BlackCat]

Hi Pragati11, is there a way to share my PBIX file, I don't think I have options to perform this on this platform? I have been trying to figure this out the past couple of weeks, any assistance is appreciated.

[Pragati11]

Hi @BlackCat ,

Upload your pbix on dropbox and then share the link or you can use weTransfer:

https://wetransfer.com/

Thanks,

Pragati

[BlackCat]

I will use we transfer, what is the email address that I should send to?

[Pragati11]

Hi @BlackCat ,

You don't need my email address for this. Send it to your email address. A link will be attached in your email then share that link here. 

[BlackCat]

Yes, how would I share my pbix file, the weighted revenue is fine, it's the weighted GM$ that is showing incorrect decimal.