Forum Discussion
Adding Differing Targets to a Combo Chart
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.
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.
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.