Numbers to string for chart axis

[ahrensims]

I have order #'s in Excel, and would like them to come in to Power BI as a string. Even when I format the font in Excel to be a string, they keep coming into Power BI as sumarized numeric fields. I would like to show the order #'s as an axis in a chart, with a count of product ID's. How can I do that?

[andre]

In Excel Power Pivot you can click on a column then go to Advanced->Summarize By->Do Not Summarize.  This feature is still missing in Desktop but hopefully it will be coming there soon.

[Greg_Deckler]

Sounds like you need to use Power BI Desktop or Excel where you can set the type of column to Text or perhaps create a calculated column using CONCATENATE or other function to force a string.

[ahrensims]

Right. I ended up concatenating # & Field, which made it recognized as a string.