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 only allow me to plot a count, average, max, min etc but never the actual data. How do I do this?

Need Help

12 Replies

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution 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.

      • Seanan's avatar
        Seanan
        Icon for Solution Supplier rankSolution 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.

    • Seanan's avatar
      Seanan
      Icon for Solution Supplier rankSolution Supplier
      4 years ago

      Hi Kampua 

      Could you please click on your chart with your columns added and send a picture of your visualisation pane, showing all of the fields you have used.