Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Column value legend based on slicer

Hello,

 

I have the issue with showing data for sales of two companies (company A and company B). Companies sell to 3rd parties, but there is also cases where company A sells to company B and then it resells to 3rd party and I need that to be reflected. Currently in diagram I have column where these sales are reflected as "comp. A sales to comp. B" based on:

IF(AND(('2022'[Seller])="A",('2022'[Buyer])="B"),"A to B",

this is okay if showing consolidated information. But when I want to see only one specific company I need to have info if it was sold directly or as a resell. So e.g. if 500 units were sold from A to B, while viewing A company reports it should appear as direct sales, and when viewing company B it should show as resells.

 

What idea I have is somehow work with slicer itself, if I choose company A the formula above will be added as direct sales, and if B selected added to resells. Unfortunately, not sure how to do that exactly best way possible. Also other work around ideas are welcome. Thanks for input.

 

 

Need Help

2 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

    Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

     

    It makes it easier to give you a solution.

    1. Sample (dummy dataset) data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.

     

    Best Regards,
    Community Support Team _ Zeon Zheng

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