Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Rebecka Nylin]

Hi,
I have a report where I would like to present data from my Top N customers (N is selected in the report).
To present which customer that are my Top N is no problem (see visual with header AntalEval_name by name).
But the problem is to the present data connected to my Top N customers (see visual with header AntalEval_result by result).

The second visual is not correct.
I would like to present the highlighted yellow data in the visual below. That is the result for my Top N customer (when N=3 my top customers are b, c, d, e, f, according to the above visual (b, c and e are in shared 3rd place)).

How can I fix this?
See attached file.

——————————
Rebecka Nylin
——————————

[Sam Duval]

Thanks for posting the file, I don’t know why it’s happening, but it seems to be something to do with distincting the values down. If I add name to the table it shows the records you expect to see, but then it shows each value for each name, which I don’t think you are wanting to see. I’ll play with it more and see what I can figure out

edit.. still don’t know what is happening but it appears to only be when you select top 3
——————————
Sam Duval
Data Quality Analyst
Indianapolis
——————————
——————————————-

[Sam Duval]

Look like if you add key to legend, it fills all the expected categories. Let me know if that’s not what you were after

——————————
Sam Duval
Data Quality Analyst
Indianapolis
——————————
——————————————-

[Rebecka Nylin]

Hi!
Yes, add key to legend works fine! 
My problem is now how to fix the above in a line chart with a date axis…

——————————
Rebecka Nylin
——————————
——————————————-