Columns/Fields when added to visualization table gets prefixed with First, how can I avoid it?

[Anonymous]

Fields/Columns when added to matrix visuazation table, gets prefixed with "first" or "sum" or "count" etc.. I want the field names to be represented the same as it is without any prefix.

- I know renaming is an option to remove the prefix that got added. I have several fields( >1000) and I don't want to be manually renaming one after other. 

Is there an option to avoid field names getting prefixed?

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Based on my research, it is by design, I am afraid you could not avoid the prefix currently if you do not want to manually rename each field, I suggest you submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He

[Anonymous]

Thanks Daniel He,

Yes, I voted for development of this features. will be really helpful when it releases.

Thanks

Sripriya!

[v-danhe-msft]

Hi @Anonymous ,

Ok, don't forget to mark one reply as answer to close this topic.

Regards,

Daniel He