Forum Discussion
Filter by items without data
- 1 year ago
You can create a DAX measure
IsBlankColumn =
IF (
ISBLANK ( MAX ( 'Table'[YourColumn] ) ),
TRUE(),
FALSE()
)Add this IsBlankColumn measure to the Filters on this visual section in Power BI.
Set the filter to show only the TRUE values. This will filter the matrix to show only the rows where the specified column is blank.💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn - Anonymous1 year ago
Thanks for Kedar_Pande and samratpbi's concern about this issue.
Hi, Pini
Since you didn't provide a dataset to perform the test, I created a simple one myself:
As Kedar_Pande's said, you can create a Measure to mark whether a particular row of the column is null.
Also you can create a Calculated column to mark if a row of that column is null:IsEmptyColumn = IF(ISBLANK([Quantity]), 1, 0)
Then drag the Calculated column to ‘Filters on this visual’ and set it to 1. This will filter out the data where Quantity is null:I have attached the pbix file for this simple example below, hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can create a DAX measure
IsBlankColumn =
IF (
ISBLANK ( MAX ( 'Table'[YourColumn] ) ),
TRUE(),
FALSE()
)
Add this IsBlankColumn measure to the Filters on this visual section in Power BI.
Set the filter to show only the TRUE values. This will filter the matrix to show only the rows where the specified column is blank.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
- Pini1 year agoNew Member
When I create the measure and apply the filter it doesn't give me the option to filter anything. It doesn't give me the option to choose true or false. It is as if there were no data in that column but in reality there is.
- Pini1 year agoNew Member
When I create the measure and apply the filter it doesn't give me the option to filter anything. It doesn't give me the option to choose 1 or 0. It is as if there were no data in that column but in reality there is.