Forum Discussion

Consta's avatar
Consta
Frequent Visitor
4 years ago
Solved

Visualising simple table as diagram

Hello! Im new to Power BI. I've got a table from excel (first image) which is illustraded as a linear graph in excel. (second image). I want the same illustration in Power BI. So i want my x axis ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Consta ,

     

    According to your description, you need to modify your data model appropriately in power query. Converted to a table structure similar to the following. Then put the corresponding fields in the line chart visual, refer to the following:

     

    Note that the field type of value needs to be changed from text to whole number, otherwise an error will be displayed.


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Consta ,

 

According to your description, you need to modify your data model appropriately in power query. Converted to a table structure similar to the following. Then put the corresponding fields in the line chart visual, refer to the following:

 

Note that the field type of value needs to be changed from text to whole number, otherwise an error will be displayed.


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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