Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
pisca
Frequent Visitor

How to create multi-graphic-line | Monthly Target

Hi,
I would like to arrange monthly target with different values which integrated/connected to product category that i have.
The power bi data as follows :

https://file.io/6l8hzg940SCg

 

The point that i need you to help is :
- How to create a new graphic-line on table for the target which had different color with the other graphic-line so it could be generated.

The expected output should be as following pict in red-graphic-line :

target_accessoris_category.png
target_computer_category.png
*FYI, the red-graphic-line in attached file was manually drawn with paint

5 REPLIES 5
AnkitKukreja
Super User
Super User

Hey! @pisca 

I saw you're model, there are a lot of things that are missing in the model, for you to get the correct results.

Please include a date table in your model (best practice, this helps you with time intelligence calculations).

Once you have your date table, create relationship with your dates and also instead of month number in your targets table. (ss below). With the month number 1,2 Power BI doesn't know which month and year target you're referring to. It's just a number that is repeated 3 times in the table. It should be a date.

 

 

AnkitKukreja_0-1623489823663.png

 

In case if you need help, please make this changes to the model and send it to me and I can look at it again.

 

Thanks,

Ankit

Linkedin 

Gmail 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Sorry, I couldn't clearly understand with features in Power BI since technically, I'm not capable on it. That's why i need you help how to make the target-line on this graphic.
Would you mind to help by providing example as per your explanation?

Hi @pisca 

I can help you, but please add dates in your targets table instead of numbers, and please send it again, I can resolve this.

 

Thanks,

Ankit

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Please share your actual pbix file, because I feel there is something missing here and it's not working because you've manually created a sample data.

 

Thanks,

Ankit

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.