Forum Discussion

pisca's avatar
pisca
Frequent Visitor
5 years ago

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 poi...
AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
5 years ago

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.

 

 

 

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 

  • pisca's avatar
    pisca
    Frequent Visitor
    5 years ago

    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?