Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi all,
I'm new to Power BI so was after some help with targets. Any help would be greatly appreciated.
I currently have a graph showing totals per group over the last 4 years + current year to date. I would like to add a target line in the table which would start at 2013, this target would be calculated by taking the average of this group over a 4 year period (2012/13/14/15), every year after this would be 6% year on year.
I have already worked out the targets for each groups and created the separate table. I have a column in the graph data table and target table to link together but can't see how I would link the target data in to the graph on specific group and year.
Is there a way I can calculate Targets on the fly?
Can I add targets to a table from a different data set?
Thanks in advance.
Dear @KelvClark,
I really care about the problem you are having, but I still not understand it clearly.
Could you please describe the problem more clearly with a more detailed illustration (by image).
When understand more your problem, I hope I can support you.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
4 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
4 | |
3 | |
3 | |
2 |