Blank Values in Slicers

[newpbiuser01]

Hello everyone,

I have a question about the slicers and blank values in the data - would anyone know if its possible to sort the data in a way that the slicer shows the blank values at the end, so the slicer below would have the blank option at the end (below Medium)?

Thank you!

[Greg_Deckler · Accepted solution]

@newpbiuser01 *might* be able to create a calculated column that you use as a Sort By column. That's a setting in the Table Tools ribbon tab. Kind of depends on the data though but might be as simple as:

Column Sort = 
  SWITCH([Column],
    "High",1,
    "Low",2,
    "Medium,3,
     4
  )