Forum Discussion

katto16's avatar
katto16
Helper I
3 years ago
Solved

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...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    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! ❤️

parry2k's avatar
parry2k
Super User
3 years ago

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! ❤️