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 I set up a Many:1 relationship between the two tables by using the Location Column. I posted Example Data above
Which Location are you using in the line chart? You need to use the Location from the Target table. You will still need to use an aggregation, but if your table is built properly it won't matter if you use SUM/Avg/max as they'll all give the same result.
The one from the target table. It just shows the total target for all locations, which doesn't change when I select a location AllisonKennedy
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?