Results 1 to 2 of 2

Thread: Dynamic / Multiple Slicer Selections

  1. #1
    Neophyte IH8DATA's Avatar
    Join Date
    Oct 2018
    Posts
    4
    Articles
    0
    Excel Version
    2016

    Dynamic / Multiple Slicer Selections



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all, it has been some time since I have posted here but I am stuck.

    In this case I am using CPG data and need help comparing a companies sales data to their competition. In the sample data you will see 4 unique entries for "Company", Acme, Acme Competition, Smart Div and Smart Div Competition. In this example I want to compare the sales for Acme against the sales for Acme Competition. Ideally I would have my user select a slicer for Acme (not Acme Competition) and display both the data for Acme & Acme Competition. Note that there will never be a comparison for Acme Div and Smart Div.

    I am trying to stay away from hard coding companies, such as a measure like, Acme Competition Sales:= CALCULATE( [Sales] , data[Company] = "Acme Competition" ). I am also trying to stay away from cubes.

    Hope this was *somewhat* clear.

    Thanks
    Attached Files Attached Files

  2. #2
    Neophyte EKelly's Avatar
    Join Date
    Dec 2018
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Guessing this is long since answered by you however on the off chance that it is not


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •