Blank value in button slicer

Hi all, I have a semantic model (storage mode direct lake on onelake) in Fabric. I have a pbi report connected to it. The model is as follows: dim_Customer fact_Contract fact_Invoice Custome...

Need Help

maruthisp

Super User

6 months ago

Hi JS23,

You can do below:

1.Remove Blank Using visual-level filters
2.Replace Blank with a Label (“Unknown”, “Not Assigned”)

CategoryNameFiltered =

IF (

ISBLANK ( 'Category'[CategoryName] ),

"Unknown",

'Category'[CategoryName]

)

Please let me know if you have any further questions or need clarifications.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!

Best Regards,

Maruthi

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/

X - Maruthi Siva Prasad - (@MaruthiSP) / X