Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BlackCat
Helper III
Helper III

Can't change decimal in format

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.

1 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:

Pragati11_0-1609776703379.png

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

31 REPLIES 31
parry2k
Super User
Super User

@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?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Pragati11
Super User
Super User

Hi @BlackCat ,

 

Is this what you are looking for:

Pragati11_1-1609776206581.png

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

It looks correct but should be displaying 10,416.67

Hi @BlackCat ,

 

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

Something like below:

Pragati11_0-1609776703379.png

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

That worked!! TY!!!

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.

Hi @BlackCat ,

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.

Hi @BlackCat ,

 

Turn on ROW SUBTOTALS as shown below:

Pragati11_0-1609778599506.png

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

Hi @BlackCat ,

 

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

Pragati11_0-1609779393783.png

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

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

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.

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Pragati11
Super User
Super User

Hi @BlackCat ,

 

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

Can you share your pbix file ?

 

 

 

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.

Hi @BlackCat ,

 

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

https://wetransfer.com/

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

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. 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors