Forum Discussion

swheeler's avatar
swheeler
Regular Visitor
3 years ago

benchmarking in Power BI - query

Hello

 

Can anyone tell me how I solve the following (I am new to Power BI)?

 

I am looking to perform benchmarking of data.  We have existing data values and new client data which will be added to the same value set.

 

When the new client data is selected by a slicer for comparison against the larger dataset we need for the larger dataset values (LQ, Med< UQ)  to NOT include the data that is selected by using the slicer.

 

Is this possible, and, if so, how?

 

Kind regards

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi swheeler ,

    I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_ Binbin Yu