Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nkasdali
Employee
Employee

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

@nkasdali,

 

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

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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

@nkasdali,

 

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

Works well dude 🙂 thanks

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.