Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey peeps,
i already tried to find a solution by searching around in BI itself, but no success.
Lets assume we are importing an Excel sheet that is provided by another user. Now we want to use this form as a mapping table for our project. It contains a huge amount of columns with numeric values in it.
PowerBi now sets every column with the logic "Summarization: Sum". I did not find any way to select all columns and set them all to "Don't summarize". By today, i do not understand the advantage of this automated recognition...neither the useage of this summarization. Perhaps someone can explain it to me.
I could bypass that legwork by unpivoting the columns, but this should not be the usual way, or?
Is there an option to turn this issue off?
Thanks for your help
Solved! Go to Solution.
Yes, you may take a look at Setting common properties.
@NovaBI , By default all number data type will get default summarization as sum. If you do not want them to summarize change data type to texr
@amitchandak thanks for your answer.
So there is no way to do a multiple select of columns and change them in one step? I do need to change the sum yes/no column by column?
Appreciated and regards
Yes, you may take a look at Setting common properties.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |