Forum Discussion

CraigC's avatar
CraigC
Helper I
8 years ago

Target vs total sales column chart

Hi There,

 

So i want to display on either a clustered column chart or a line and clustered column chart the total amount sold vd the target. Total amount sold is a sum of BILLTOTAL. The BILLTOTAL is a sum of each sale. The target is simply a static number.

 

Target and billtotal are in two seperate tables linked by a relationship. When i create the column chart the axis is the short month name, the value is the SUM of the Target which displays the proper target. Then the only way to get theTARGET on is by placing it as a tooltip also as SUM which then you can see the target by hovering over the month. Alternatively i can place it as a sum of a linevalue which then actually displays on the chart but i would like it side by side per month on a column chart if possible?

Need Help

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi CraigC,

     

    If I understand you correctly, you should be able to simply show Month column as Axis, both Total Sales and Targets as Values on a clustered column chart in this scenario. :smileyhappy:

     

     

    Regards

    • CraigC's avatar
      CraigC
      Helper I
      8 years ago

      Hi v-ljerr-msft

       

      That is exactly what im looking for but when i place both the Target vs Actual the values are the exact same unfortunately. I think there might be something with the relationship of the tables as they are from different tables.

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        8 years ago

        Hi CraigC,

         

        Could you share a sample pbix file(with just some sample/mock data) which can reproduce the issue, so that I can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

         

        Regards