Forum Discussion
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:
- Name
- Address
- 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! 🙂