Forum Discussion

sabsBI's avatar
sabsBI
New Member
4 years ago

Bar Graph creation in Power BI Desktop

Hi, I'm quite new to Power BI, it seems that when creating a bar graph the formatting of my table isn't exactly correct. I've attached an example table for simplicitity, essentially I'm trying to get...
Need Help
Tutorial Requests
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
4 years ago

Can you not simply add the three columns of Apple, Peaches, and Strawberries to the Values drop zone of the chart?

Hint: you may need to remove the n/a values and make it an INTEGER type.

Everything else becomes dimensionaltiy (Owner, Farm #, Quarter) and those can be Legends in the chart, or filters on a slicer.

QQ: You mention AVERAGE. Is that different than the number you are showing? If so, what is your definition of Average? Average of WHAT?

  • sabsBI's avatar
    sabsBI
    New Member
    4 years ago

    Hi thank you for your super fast response, that's the issue the fields I have are x-axis, y-axis, legend, small multiples, tooltips, but there is no values field. 

     

    Also for average I should be good, I would just change it from sum to average in the bar graph once it's set up but I cannot figure out what the replacement for the values field is.

     

    Thanks again for your help!

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi, sabsBI 

      Have you checked the field data type of these three columns ( Apple, Peaches and Strawberries )?

      Make sure their data type is decimal.

       

      Best Regards,
      Community Support Team _ Eason