Remove Null values from a column
Problem statement: To hide null/redundant columns from Power BI visual (Matrix)
Brief case: For a particular item code, there are some set of columns which are null. The requirement is to display only those columns which have at-least one value in them and hide which are completely null.
For better understanding refer the image below
Scenario 1: - If user selects ID=4, then column = “Mother’s name” should be hidden
Scenario 2: - If user selects ID=3, then column = “Mother’s name” and “XYZ” should be hidden
This should happen dynamically whenever a user selects any ID, columns which are not having any value should be hidden
Future Prospect: Will there be any kind of Functionality/Feature that would be available in future updates from Microsoft to solve problem like this?