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...
Need Help
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
Icon for Community Support rankCommunity 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.