Forum Discussion

Danysh's avatar
Danysh
New Member
3 years ago

PowerBI column data error

how to show text and number in power BI
Need Help
Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
3 years ago

Danysh 
Could you please elaborate the question.

Thank you.

Danysh's avatar
Danysh
New Member
3 years ago

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.

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Continued Contributor
    3 years ago

    Danysh 

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

     

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Community Support
    3 years ago

    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.