Move blank value in slicer to bottom

[hideakisuzuki01]

Hi,

There is a "Blank" value in slicer as in the below screenshot.

Is it possible to move this blank value to the bottom of the slicer ?

Regards

[hideakisuzuki01]

Thanks Pragati !

[Pragati11 · Accepted solution]

Hi @hideakisuzuki01 ,

No that's not possible. Blank() value always comes up at the top.

But if you want it to be displayed in the end of your slicer, may be you can create a Index column for the values in the DEPARTMENT column. Give BLANK() as the last numeric value on the INDEX column ans sort Department column by this new INDEX column. This should give you BLANK() value in the last on your slicer.

Index values can be something like below: (BLANK has the last/maximum index value)

Without adding index and sort on Department column, the slicer is shown below and has (BLANK) as the first value in the slicer:

After creating an INDEX column on your data in Power BI, you can sort your department column by this index column as shown below:

Now if I go back to your slicer, it is sorted accordingly showing (BLANK) value as last option on the slicer:

This way you can achieve what you are looking for. 🙂