Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
Regards
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.
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.
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |