Forum Discussion

Jakki's avatar
Jakki
Frequent Visitor
5 years ago

Adding Differing Targets to a Combo Chart

Hi Community,

Fairly new to Power BI and hoping you will be able to help.

I have a chart showing staff activity and would like to include a target line (each person has a different target, as shown in the images attached).

 

When I add the highlighted column to the Line Value this gives me 1 total value for each user.

 

Any help you can offer would be apprecaited.

Need Help

3 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Jakki ,

    Sorry for replying late. Based on your description, did you mean when you put the column into the line value field, it just show a single value, not each corresponding value for each user?

    If so, please check the aggreation of the column should be Sum:

    By the way, how did you create the chart visual? The field in the chart seems not match with the data table. I have attached a sample file in the below based on the above sample data. If the above not help, maybe you can consider sharing a dummy .pbix file or modify my sample file, it could help you better to solve this issue.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • Jakki's avatar
      Jakki
      Frequent Visitor
      5 years ago

      Thanks for your reply - unfortunately this didn't work.

       

      I've attached a copy of the chart and also an example of the fields being used in each of the tables.  Relationships are all set up accordingly.

       

      Any further help apprecaited.

      • v-yingjl's avatar
        v-yingjl
        Community Support
        5 years ago

        Hi Jakki ,

        Based on your sample picture, I could only guess there is a relationship between [UserCode] field in Users table and [CreatedByUserId] filed in Leads table. If I got it correctly, that could be the problem.

        Please check the crossfilter direction of this relationship is both instead of single.

        If the direction is single, you could get all the same value for each user, when you change it to both, the value should be correct.

        single directionboth direction

        About crossfilter direction, you can refer this document: Cross filter direction 

         

        Best Regards,
        Yingjie Li

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.