Forum Discussion
Resolver IFormatting issues on PBI desktop
Community Championit 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.
Resolver IHi, 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