Forum Discussion
Dynamic target line
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!
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! ❤️
1 Reply
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! ❤️