Removing (Blank) from my page filter

[PBIMakesMeHigh]

Hello

I have a page level filter "MOP (Key)".  For some reason, there is a (Blank) that can be selected for "MOP (Key)".  Can someone please advise why this is happening and how can I remove it?  I do not see any blanks in my "MOP (Key)" table.

Thanks for the help.

I can also share the pbix file, if it's possible to upload it here?

The "MOP Key" is linked to the "OneStream (Actuals)" tab, which the excel file also does not have any blanks.

[Idrissshatila · Accepted solution]

Hello @PBIMakesMeHigh ,

so what is happening is that in your onestream actuals table you have a value of the Mop key that is not in the Mop key dimension fiels thats why its showing blank.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin