Forum Discussion

Frodo_Panda's avatar
Frodo_Panda
New Member
3 years ago

Filter out Blanks From Multiple Columns using 1 Filter on Power BI Desktop

Hi Team,

 

This might have a very simple solution but I was not able to find anything online.

 

So the situation is that I have imported a table similar to the below screenshot: 

 

Now, I am required to present a Silcer on Power BI Desktop which has 3 options:

  1. Name
  2. Address
  3. ID

 

If the end user selects Name then the table on the screen will display the following Non Blank Values for Names but include Blank Values for other Column:

 

If the end user selects Address then the table on the screen will display the following Non Blank Values for Address but include Blank Values for other Column:

 

If the end user selects ID then the table on the screen will display the following Non Blank Values for ID but include Blank Values for other Column:

 

Thank you in advance for the help! 🙂 

No RepliesBe the first to reply