Notifications
Clear all
Power BI
2
Posts
2
Users
0
Reactions
95
Views
Topic starter
How can I add a target/budget constant line for different year
Posted : 08/09/2019 10:07 pm
Hi Grace,
You need to write a measure that filters the result for the year you want. e.g.
=CALCULATE(SUM(Table[Column]), DimDate[Date]=2018)
Then you'd just add this to the chart as another series, as opposed to a Constant Line.
Mynda
Posted : 09/09/2019 5:27 am
