Forum Discussion
Solved
Dynamic Target Line with bar chart
Hi all, I am looking for a way to create a stacked bar chart with a target line. The target line has to be dynamic depending on the filter criteria selected. At the moment, I have two different...
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?
AlinaJa , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Example
CALCULATE(Average(Sales[Sales Amount]),all(Sales))
CALCULATE(Average(Sales[Sales Amount]),allselected(Sales))
| Month | Location | Inventory |
| 1 | Germany | 1000 |
| 1 | US | 2000 |
| 1 | China | 2000 |
| 2 | Germany | 1500 |
| 2 | US | 1000 |
| 2 | China | 1000 |
| 3 | Germany | 1300 |
| 3 | US | 2500 |
| 3 | China | 2000 |
| Location | Target |
| Germany | 1000 |
| US | 1500 |
| China | 1500 |
I made up some sample data to simplyfy it. amitchandak