Forum Discussion

Kampua's avatar
Kampua
Regular Visitor
4 years ago
Solved

How to build a graph using given data?

New to PowerBI here be kind. I have a simle table with date on one cilumn and some values on another column, I need to plot a simple line graph. However PowerBI does not allow me to do so, it will on...
Need Help
Seanan's avatar
Seanan
Solution Supplier
4 years ago

Hi Kampua 

Could you please check that the data type is set to Date in the Data tab. See screenshots below. 

Click on data table -> Click on your date column -> check data type

 

 

 

 

 

Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.

Kampua's avatar
Kampua
Regular Visitor
4 years ago

 

  • Seanan's avatar
    Seanan
    Solution Supplier
    4 years ago

    Hi Kampua 

    If you click on your line chart, in the visualisation pane, click the drop down arrow next to Planned Quota in the Y-Axis and is there and option called don't summarise?

    If not could you also check that your planned quota column is of the data type Whole Number.

    • Kampua's avatar
      Kampua
      Regular Visitor
      4 years ago

      There is no "don't summarise" option,

       

      Yes it is whole number.

      • Seanan's avatar
        Seanan
        Solution Supplier
        4 years ago

        Hi Kampua

        Would it be possible for you to send your PBIX file without any sensitive data?