Forum Discussion
Resolver IFormatting issues on PBI desktop
Community Championsince 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.
Resolver IOk 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:
- 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?