I cannot share my file due to privacy issues so hopefully all of these screenshots will be helpful.
There are no visual or page level filters set, no slicers and the column auto-size is set to "On". From this veiw everything looks like it's working correctly, especially since the number of characters in the total row are greater than the ones of the column header.
I have added one page level filter to example #1 and the column auto-size remains "On". You can see here that the auto-sizing breaks and does not format the May column correctly.
Adding additional selections to the page level filter still provides the same result as example #2
Clearing the page level filter and using a visual level filter provides the same result
Clearing page and visual level filters and using slicers also results in the same outcome.
I have searched in the fourm for answers to this and have looked at any possible formatting selection I could make to correct this (I'm still new to PBI so that doesn't mean a whole lot lol) but I cannot figure it out.
Does anyone know how to fix this? It seems as though it's the filters causing the issue...?
The value column is a count of the "parent appointment ID" which is a numerical (whole) number.
I have had this happen on more than one occassion in more than one page.
My desktop PBI is current - Version: 2.65.5313.841 64-bit (December 2018)
If I manually adjust the May column and go up or down a level the column will revert back to the wrong format where the total does not fit as seen in examples 2-5