Dynamic target line

[katto16]

Hi guys. I have a bar chart of the date vs sum of orders on that day. 

I have another table that consists of the date and the target number on that day. I want to use that table to create a dynamic target line on this bar chart. The table is smth like this

Date           Tartget

12/8/23      800

13/8/23      1000

I want a line here based on the data on my another table. Will this be possible? 

Thanks for the support!

[parry2k · Accepted solution]

@katto16 you need to add a date table in your model which will have a relationship with both the table on the date column, and then in visual, use the date column from the new date table on the x-axis and values from the respective table and that will do it.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️