Forum Discussion

sd_09's avatar
sd_09
Frequent Visitor
1 year ago
Solved

PowerBI - Matrix table blanks

Hi,    I have a matrix table on PowerBI and I have columns in it from multiple data sources. I also have some filters. I want to get rid of the blanks when filters are applied etc. Is there a way t...
Need Help
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi sd_09   ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    I tested the scenario using the following sample data:

     

     

    I then created a calculated column to flag rows with at least one non-blank value:

    ShowRowFlag =

    IF (

        NOT (

            ISBLANK ( OrgData1[Score1] ) &&

            ISBLANK ( OrgData1[Score2] ) &&

            ISBLANK ( OrgData1[Percentage] )

        ),

        1,

        0

    )

    I added this column as a visual-level filter, and set it to show only where ShowRowFlag = 1.

     

    And got the result like below. Please go through the pbix file

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

    Best Regards, 
    Community Support Team  

     

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

The images should show the entire table/visual otherwise I cannot understand

sd_09's avatar
sd_09
Frequent Visitor
1 year ago

This is the table: 

and this is what happens when I filter:

Is this clearer?

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi sd_09   ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    I tested the scenario using the following sample data:

     

     

    I then created a calculated column to flag rows with at least one non-blank value:

    ShowRowFlag =

    IF (

        NOT (

            ISBLANK ( OrgData1[Score1] ) &&

            ISBLANK ( OrgData1[Score2] ) &&

            ISBLANK ( OrgData1[Percentage] )

        ),

        1,

        0

    )

    I added this column as a visual-level filter, and set it to show only where ShowRowFlag = 1.

     

    And got the result like below. Please go through the pbix file

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

    Best Regards, 
    Community Support Team  

     

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi sd_09 ,

    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

     

    Thank you.

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi sd_09 ,

    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

    Thank you.

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi sd_09 ,

    Can you please confirm whether the issue has been resolved. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need. 

    Thank you.