Forum Discussion
Suppressing "Blank" Rows (formatting issue?)
I have a requirement where the users don’t want to see rows where there are no values displayed in any columns in a Matrix visualization. I believe PBI automatically does this (unless you ask it not ...
Thank you. I just came up with essentially the same solution. So far my numbers are tying out but I'm worried I'm going to end up with rounding issues because this logic is essentially throwing away values between -999 and 999. Any thoughts on that?
johnt75
Super User
Super UserAs your format string is already effectively removing those values then I don't think it would be a problem at the individual row level. It could cause issues at the total level, depending on how the totals are calculated, as the values between -1000 and 1000 would potentially be included in the total but not show up in the rows.