Slicer that excludes null from options, but always includes null in dataset

[robhill]

Hello,

My data comes in so that actuals and forecast data are combined in a single table. Every month, a new forecast is created so there are multiple versions of the forecast. Each Forecast gets a version. For the Actual data, the "Versions" shows null. 

Month	Type	Version
Jan	Actual	null
Feb	Actual	null
Mar	Actual	null
Mar	Forecast	Feb_FC
Apr	Forecast	Feb_FC
May	Forecast	Feb_FC
Jun	Forecast	Feb_FC
Apr	Forecast	Mar_FC
May	Forecast	Mar_FC
Jun	Forecast	Mar_FC

For example, in the data set above, creating a slicer using the "Version" column would give you 3 options:  

• null
• Feb_FC
• Mar_FC

I want to remove "null" from the slicer, but without actually filtering out the null data.  (Put another way, I want to always include null, giving users the option to filter between Feb_FC or Mar_FC). 

Any idea how this could be accomplished?

Thanks in advance!

[v-yuta-msft]

@robhill ,

I'm afraid this couldn't be achieve in power bi desktop.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.