How to remove blank option from slicer

[Joshua]

Hi,

Could anyone please guide me,

How to remove the blank option from slicer.

Thanks,

Joshua

[Greg_Deckler]

Generally this is a data relationship issue.

[Joshua]

Hi,

I am using  nearly 5 slicers,

but only I am getting this type of issue in one of the two slicers.

Is there any tricks to solve this out?

Thanks,

Joshua

[Anonymous]

Generally this means that... you either HAVE a blank in your data... or, that you have a relationship... and the lookup table (the 1 side of your 1 to many relationship) doesn't have EVERY value from your fact table (the many side of the relationship).

The easy way to find it is to add a calc column on the fact table, that is =RELATED(LookupTable[SomeColumn]), then look for the BLANK in the new calc column.

[Sean]

@JoshuaTo solve this right away - switch to the Hierarchy Slicer

To find out why/when it happens read here - specifically @OwenAuger's post on page 2

http://community.powerbi.com/t5/Desktop/SLICERS-gt-blank-value/td-p/6726/page/2

(For me it happens in a bit different scenario than the example given by Owen - mine involves 4 tables but same principle)

The way I resolved it in my case (Note - I don't know if this would make sense/apply in yours)

I created a new COLUMN in the "many" table - use RELATED ( One SideTable[SlicerColumn] )

to bring to the "many" table only the values you need - and then use this new column instead for your Slicer

Again please note that this works in my case which is slightly different than Owen's example because

selecting Blank in my slicer results in all charts measures visuals showing nothing

unlike in Owen's example which actually if I recall displays a value when blank was selected in the slicer!

(hope this makes sense)

Good Luck!

[prhodesbajaj]

Thank you for that tip. I downloaded the Hierarchy Slicer and my problem was solved.  The old way of filtering then changing to a slicer no longer works.