Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slicer default option

I have created a slicer to filter the page either based on the Sale or Profit as shown in the picture:          Therefore, we should select either Sale or Profit. but When we select two of...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

LivioLanzoDear Livio, 
thank you for answering, but I'm afraid I didn't understand what should I do exactly? 
So what do you mean by slicer[header]?? 

And should I write this as a measure and then add in as my Slicer field? 

Thank you for your help 

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

For your error, I need to know more about your data sample.

 

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

In addition, do you want to set the default slicer value? If it is, you could refer to this blog.

 

Best  Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-piga-msft

    I am using AdventureWorksDW data samples. 
    You can find the report in the attachment. 
    I thank you in advance for your help 

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      Hi Anonymous,

       

      Based on your sample, I found that the issue is caused by the measure Final Selection your created. 

       

      If you use values function it will return mutiple values which will cause this error.

       

      Please modify your measure like below to have a try.

       

      Final Selection = SWITCH(TRUE(), 
    SELECTEDVALUE(Selection[Option])= "Sales", [Total Internet Sale],
    SELECTEDVALUE(Selection[Option])= "Profits", [Total Internet Profit], 0)

       

      Best  Regards,

      Cherry

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        v-piga-msft
        Thank you so much. I can't believe this could have been solved so easily !!!:smileyindifferent:

        This is exactly the equivalent for the :

        Option Select =
IF (
    HASONEVALUE ( Selection[Option] ),
    VALUES ( Selection[Option] ),
    MAX ( InternetSales[SalesAmount] )
)

         

        Thank you for your clever answer