Forum Discussion
Receiving Cannot mix text with values error
It turns out you can sijmply use the formatting in the table view and with will apply that correct formatting to numerical outputs while leaving the texct outputs alone. I had assumed this would cause an error but it has not yet done so.
I would like to help but I'm a little unclear about your requirements.
Can you provide the following?
1) Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
3) Please explain how you would expect to get from step 1 to 2.
4) If possible, please show your past attempts at a solution.
A .pbix file with sample data would be best.
Sorry, yes I can give sample data, I knew I was forgetting something important.
The two columns used are strictly numerical. They would look something like this:
AC[Production] DPP[Daily Amount] 12.5 13 32 21 1.125 2 The hoped for outcome would be something like this:
ID % Commitment 12345 55.4% 54321 Excluded 45321 120.5% 35432 Needs Review 25314 Excluded 24351 68.9% I got it working without the formatting, it's formatting the output when it's a number thats the problem.
Currently, If I strip out the FORMAT stuff I get:
% Commitment 0.55 Excluded 1.20 Needs Review I hope this helps, I just looking for a way to take what I have and format the numbers so any solution that obtains that is gold. It doesn't have to be the approach I took.