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
  • v-piga-msft's avatar
    v-piga-msft
    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

  • xonde's avatar
    xonde
    7 years ago

    GOOD NEWS!! The Power BI March 2019 Update just released a custom visual called the "Power Slicer" you can import this visual from the marketplace. This visual has a million more options than the normal slicer and more importantly allows you to set a default value. This can be done by going into the format tab under the "selection" options and setting the default value to a literal in your list.

    For example if you had a power slicer with a bunch of years in it:
    .2015
    .2016
    .2017
    .2018
    .2019

     

    You can set "Default Selection" to be "2019"(minus the quotes). But if you want it to be dynamic and always show the current year, then even more good news, this options accepts javascript, so you can set the "Default Selection" to "(new Date()).getFullYear"(minus the quotes)  and the Default will always be the current year. If you have a more specific need you can always google it for some javascript help, and someone on StackOverflow will probably have your answer.

     

    Heres a link to the video (Skip to 14:43): https://www.youtube.com/watch?v=rBPGH6eYlT0&feature=youtu.be&t=10

    Hope this helps,

    Xonde.

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

try with the hasonevalue function

 

=
IF (
    HASONEVALUE ( slicer[header] ),
    SWITCH (
        VALUES ( slicer[header] ),
        "measure1", [measure1],
        "measure2", [measure2]
    ),
    [default measure]
)

  • 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 

    • LivioLanzo's avatar
      LivioLanzo
      Solution Sage
      7 years ago

      Hello Anonymous

       

      I am assuming you're  using a small table listing the name of the measures that are displayed as you change the slicer selection. 

      What is your final measure that is linked to the slicer selection?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        LivioLanzo yes I have created a simple table with only my options in it, as follow: 

         

        And add the option column as field value for the slicer 

    • v-piga-msft's avatar
      v-piga-msft
      Resident 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