Forum Discussion

Pini's avatar
Pini
New Member
1 year ago
Solved

Filter by items without data

I have a problem that is driving me crazy. I have a matrix-type visual object made up of columns from different related tables. I have the Show element without data option activated. I need to be abl...
  • Kedar_Pande's avatar
    1 year ago

    Pini 

    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

  • Anonymous's avatar
    Anonymous
    1 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.