Forum Discussion
All Page Filter not working as expected
I have multiple tables joined with many to many relation on Business unit. Also, I have created a all page filter of Business unit but on few charts if I apply the all page filter on Business unit it...
Hi Pushpendra_S_R ,
According to your screenshots, it seems that Business Units= Blank are also displayed.
You may try to create a measure like:
Flag Filter = IF(MAX('Table'[Business Units])=BLANK(),1,0 )
//Or
Flag Filter = IF(LEN('Table'[Business Units])=0,1,0 )Then apply the measure to visual-level filter , set as "is 0".
If it does not work, please share me with your pbix file after removing sensitive data to help us clarify your scenario.
Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.