Forum Discussion

delish_hins's avatar
delish_hins
Regular Visitor
1 year ago

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 ...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

I think you could create a calculation group with a calculation item like

Filter low values =
VAR InitialResult =
    SELECTEDMEASURE ()
VAR Result =
    IF ( InitialResult <= -1000 || InitalResult >= 1000, InitialResult )
RETURN
    Result

Apply the calculation item as a filter on the matrix, and it should return BLANK for those values between -1000 and 1000, and so they will automatically be stripped out of the visual.

  • delish_hins's avatar
    delish_hins
    Regular Visitor
    1 year ago

    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's avatar
      johnt75
      Icon for Super User rankSuper User
      1 year ago

      As 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.