Display None or Blank option in combo box

[ak77]

Hi All

i have a requirement to get blank or none option in the combobox.. is this feature available in power bi by default? i tried few option settings.. but it didnt work. please let me know

[Daryl-Lynch-Bzy]

Hi @ak77 - Yes, but it will depend on your Dimension table.  Does it include a Null / Blank value.  For example:

ID	Value
-1	null
1	ARCA
2	ASC
3	ATRF_CLIENT
4	BALCOMP
5	FSER
6	HEEN
7	JSPR
8	JUDG

The option will be available in the Slicer now, but it will only be effective if the nulls on the Fact table are stamped with the ID -1.

Note, if the relationship between Fact and Dimension table contain a mismatch.  Exists on Fact and not on Dimension, Power BI should automatically create the Blank above.