Forum Discussion
Dynamic Target Line with bar chart
AlinaJa Maybe you could post photo or sample pbix? I don't understand what isn't working.
That is what I get when I use your sample data, with Target[Location] in the slicer, and Target[Location] in the column series of the chart (though maybe not needed).
If no location is selected, the target will add up to sum of all locations, but when location is selected it behaves as expected.
Is that what you're looking for?
AllisonKennedy The problem is that if I add the column from my target table as line values, it always gives me the sum of all targets. No matter which location I select.
If I add the target as a column to the other table and then add it to the graph as the line value, I have to choose whether I want to use the average/sum/Min/Max/... But I don't want any of these, I just want the actual value for this location.
- AlinaJa This sounds like it might be related to your data model/relationships. Are you able to post a screenshot of that view or provide an overview with confidential info removed?
AllisonKennedy I set up a Many:1 relationship between the two tables by using the Location Column. I posted Example Data above
