Showing results for 
Search instead for 
Did you mean: 
stizz001 Regular Visitor
Regular Visitor

PowerBi Preexisting Filters and Is Not Blank



I have been using PowerBI premiium embeded in our app for the last about year now.  It has been working well mostly, but there are a few quirks and I just found another I am not sure how to solve.  I have been passing in filters just fine, both Advanced and Basic, and found today a report that was not filtering when I passed them in. 


The reports filters quit working when I had a preexisitng filter where it was taking out all the blank values for a field.  In my filters, I make sure to read out existing filters, and then pass them, along with the new ones, back in.  However, when it gets passed in it has the value of [null] set for values and this seems to cause an issue.  

What do I pass in for blank?  Or how do I construct this filter correctly?  




Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 186 members 1,831 guests
Please welcome our newest community members: