Forum Discussion

PowerWhy's avatar
PowerWhy
Icon for Helper IV rankHelper IV
2 years ago
Solved

Extra row added to matrix table

Hello, When I updated to the latest power bi version these extra rows have appeared below (I've highlighted in yellow). There's no data where Period is blank and I've filtered out blank periods just...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from Syndicate_Admin , please allow me to provide another insight:  
    Hi  PowerWhy ,

    You can consider using the Filter window to deselect Blank() to filter out the empty values in the [Period] column.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Hello, I see that you have the matrix in schema format and subtotals below.

One solution is to change the format of the array to tabular and set the row subtotals

If this post helps, consider Accept it as the solution to help other members find you faster.