I am new to Power BI and this is my first attempt at uploading my budget and actual numbers. Because my budget is columnar, I needed to use the "Unpivot Column" option to sort out the Dates (which used to be the column header) and the amounts (which used to be the figures underneath the Dates header). Having done that, I then went ahead and changed the column type for both Dates (to dates types) and Amount column to "Fixed Decimal Number".
By applying and closing, I am not able to get the budget figures and get the below error. Any help would be appreciated.
Hi @MarcelBeug. I tried that option as well. Somehow it is not picking it. Is having zeros in the cells going to make the difference? When I am on the Query Editor, I can see the numbers but, when I "Close & Apply" and come out of it, the numbers simply disappear. I may be doing something wrong but dont seem to think of anything at this moment.
Thank you. I will have to run some forensic tests to clear out the data. Probably worth to round the numbers in excel to ensure there is nothing hidden. Does it make any difference if the zero appears as (0) or (-)?