Forum Discussion
Decimal Type Column behaving like text?
Hi there,
I am not able to place the field "Horas" (Hours" From table "Ausências" in the values area of the matrix visual - the data type is set as decimal. If I create a measure (sum Horas) works. I tried to summarize the field as "sum", but still does not work. I can solve this with a measure but would like to understand what is going on.
4 Replies
- andhiii079845Solution Sage
Very interesting problem. It is possible that you share this table from the PBI?
- campelliannPost Patron
Hi mate, thank you for your reply. I cant sorry. But I copied the query to a new PBIX file and there it works. Perhaps something in the advanced options...
- andhiii079845Solution Sage
Do you reopen the file, refresh all data...only a idea?
- campelliannPost Patron
andhiii079845 it seems to be a bug according to this:
https://community.powerbi.com/t5/Desktop/Default-Summarization-Not-Working/m-p/1525159#M627476