Forum Discussion

nkasdali's avatar
nkasdali
Icon for Microsoft Employee rankMicrosoft Employee
8 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
Need Help
Tips and Tricks
  • RMDNA's avatar
    RMDNA
    8 years ago

    nkasdali,

     

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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
      Icon for Solution Sage rankSolution Sage
      8 years ago

      nkasdali,

       

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

      • nkasdali's avatar
        nkasdali
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Works well dude :) thanks