PowerBI - Matrix table blanks

[sd_09]

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 to quickly fix this without creating measures for each columns or so?

Thanks!

[HarishKM]

@sd_09 Hey,
I will follow below steps to troubleshoot.

• Ensure that filters are correctly set to exclude blanks by modifying the filter pane settings.

• Use Power BI’s built-in options to format columns, setting them to exclude or hide blank values.

• In the "Format" pane, adjust the settings to hide entire rows or columns with blanks under "Rows" or "Columns" visibility settings.

• Check the relationships in your data model to ensure accurate parent-child relationships are maintained to prevent blanks.

• Use Power Query to transform data by removing or replacing blank/null values before loading into the matrix.

Thanks

Harish KM

If these steps help resolve your issue, your acknowledgment would be greatly appreciated.

[kushanNa]

Hi @sd_09 

Have you tried right-clicking on the Org column in the visual columns and unticking "Show items with no data" to see if it works for you?

[sd_09]

They are among the column values

[FBergamaschi]

In this case you need to manually filter them out. Anyway you could solve in Power Query and not see them in Power BI Desktop or in Desktop filter hem out from the filters pane

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[sd_09]

I think i incorrectly phrased my question, so there is data generically but when I filter on lets say a location, some rows dont have data. I would like to filter those rows out when data is filtered

[FBergamaschi]

I need to see some images describing the thing please

[sd_09]

This is the table

This is when I filter on something: 

The rows are organizations. I want to get rid of the blank rows/organizations when I filter

[FBergamaschi]

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

[sd_09]

This is the table: 

and this is what happens when I filter:

Is this clearer?

[v-menakakota]

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]

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]

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.

[v-menakakota · Accepted solution]

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]

Are blanks among the column values or are they visible only due to invalid relationships?