Formatting issues on PBI desktop

[Ackbar-Learner]

Hi I got two formatting issues

First: how can i get the proper format for the number nine in second line without it being in any circle, like in the first line?

Second: I am trying to format the budget figures like for actual by changing it from General to Whole number but Power Bi is simply refusing to accept the change. I did that on another measure and it worked but for this one, specifically, it is not working 😞

 Kindly help

Thanks in advance

[Ackbar-Learner]

Issue no 2 is ok now. I had to format it as currency first and then move to whole number. This is weird though 🙂

[vanessafvg]

it is really hard to see what the problem is with the information you have given.  

are you able to share your file or a sample file.

[Ackbar-Learner]

Hi, it is too complex to take out that bit and replicate in a sample file. Am sure for the 9 formatting, it's a setting issue which I cannot find.

[vanessafvg]

since you have not shown in detail what you are actually doing formatting wise currently nor in  which visual its almost impossible to know how to help you?  so you need to provide that information.

[Ackbar-Learner]

Ok so i have this P&L visual where i calculate the variance between Actual and Budget

This is the formatting i use for VarAmt: #,##0;(#,##0);" - "

This is the measure dax: 

Board05aP&LVariance = [Board04aP&LActualAmount]-[15BMProjected Amount (EUR)]

With the above, i do not know why the (9) is changing to 9 encircled. Hope it's much clearer now.

[vanessafvg]

so i think the issue with the datatype you probably have data in the field that is not a whole number which is why it can't change it, what error message do you get?

i think the problem is as you say that it is not a whole number.  once you make it a whole number it will probably fix the 9 in a circle issue, first you have to understand what data is causing it to stay general data type

you can find the trim and clean under format in power query

in power query do a trim and a clean on the column that will remove the white spaces, maybe that is creating an issue, otherwise there is some non numeric data in the field that will need to remove

[Ackbar-Learner]

I am not sure that is the issue 🙂 if you re-check the thread well, the whole number issue has been resolved albeit via a work-around. This number 9 issue is altogether another issue.

[vanessafvg]

ah ok, its unfortunately one of those strange issues, that is very hard to identify withouth actual access to the file.

if you remove the formatting you have, and set it to default, what does it do.. i think we need to try and isolate where the issue is exactly. 

where are you adjusting formatting, there are several ways?

[Ackbar-Learner]

When i put it as default formatting, it becomes -9. When i do below custom formatting, then it becomes 9 encircled 

[vanessafvg]

ok i think its safe to say that the formatting is what is causing this as this is a custom format,  however when i try to recreate the issue in my file i am not getting the same issue.    Is there any possiblity of sharing your file?    where do you set the colour to red?  also can you share a screen shot of your regional settings?

I have a feeling this is a bug, and you might need to report it to microsoft but it would be best to share your file

[Ackbar-Learner]

I tried to recreate a sample file but i don't get that issue. I set the color red using conditional formatting but that is not the issue because i removed it and the 9 was still encircled. This seems to be a bug to me. How to report this to Microsoft?

[vanessafvg]

yes i know its not the issue but i just wanted to get the full understanding of all the changes you are making. If it's not recreatable, then it might not be a bug, if you compare both versions what is different?  you would need to compare data types, values, all formatting etc.   might be the indicator to the issue. 

However if you need to create a bug  this would be the place to do it.  https://community.powerbi.com/t5/Issues/idb-p/Issues