PowerBI column data error

[Danysh]

how to show text and number in power BI

[Dinesh_Suranga]

@Danysh 
Could you please elaborate the question.

Thank you.

[Danysh]

In a column in Power BI, there is a data like P0024 and 52365 but in visuals power BI is not showing the data starting with alphabet and only showing 52365. 

I also convert it into text but still unable to get this data in BI visuals.

[v-xiaosun-msft]

Hi @Danysh ,

Can you tell me which visual you are using? If it's a table or matrix, the problem does not occur in principle, which requires you to check whether your data is imported into the report correctly. If you find that "P0024" has not been loaded, please re-import or refresh the data. 

If it's a column chart, line chart,etc., pay attention to the formatting requirements and limitations of each parameter of this visual such as x-axis, y-axis, value.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dinesh_Suranga]

@Danysh 

Please go to table view and select your table from right side panel then check P0024 in the table or not.