cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nkasdali Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
RMDNA Senior Member
Senior Member

Re: Forced value in slicer

@nkasdali,

 

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

4 REPLIES 4
Super User
Super User

Re: Forced value in slicer

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


nkasdali Regular Visitor
Regular Visitor

Re: Forced value in slicer

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 Smiley Happy.

 

regards

RMDNA Senior Member
Senior Member

Re: Forced value in slicer

@nkasdali,

 

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

nkasdali Regular Visitor
Regular Visitor

Re: Forced value in slicer

Works well dude Smiley Happy thanks