Forum Discussion

nkasdali's avatar
nkasdali
Microsoft Employee
7 years ago
Solved

Forced value in slicer

Hi All,

 

Do you know how to force a slicer to get at least one value by default ?

 

Exemple : A slicer of Month, the slice have to get one value (never blank).

 

regards

  • RMDNA's avatar
    RMDNA
    7 years ago

    nkasdali,

     

    The custom visual Chiclet slicer allows you to force a selection. Give that a try.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Typically you set the default manually and save the PBIX. When you publish it, that will be the default value of the slicer.

    • nkasdali's avatar
      nkasdali
      Microsoft Employee

      Right Greg, but the user can deselect de value, and then he will have a false KPI.

      Because i'm having cumulative Sales per month, if we don't select a month we will have a tremendous amount :).

       

      regards

      • RMDNA's avatar
        RMDNA
        Solution Sage

        nkasdali,

         

        The custom visual Chiclet slicer allows you to force a selection. Give that a try.