Forum Discussion

non23's avatar
non23
Helper I
1 year ago
Solved

Remove blank when Parameter is selected

Hey guys,

 

I need your wisdom with a matrix visualization where I have used a parameter to control the rows, allowing users to select their desired view. My goal is to hide rows that contain "Blank Approver" values when Approver Parameter is selected.

 

Here’s the issue:

  • The "Blank Approver" rows represent rejected items, which should not be displayed if the user selects an "Approved" type.
  • The challenge is that the "Blank Approver" rows should not be shown regardless of the selected type (Approved or Rejected) when the parameter is applied.

I have attached an image to illustrate how the matrix should look when both the parameter and type are selected (as an ideal scenario). Is there a way to achieve this behavior where the "Blank Approver" rows are completely hidden when only the parameter is selected?

 

Parameter selected


Parameter and Type is selected

"Help"
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi non23, 

     

    Please check the following mesuare:

    ShowRows = 
VAR SelectedField = SELECTEDVALUE(Parameter[Parameter Fields]) 
RETURN
SWITCH(
    TRUE(),
    SelectedField = NAMEOF('MainTable'[Approver]) && SELECTEDVALUE('MainTable'[Approver]) = "Blank", 0,
    SelectedField = NAMEOF('MainTable'[Rejected by]) && SELECTEDVALUE('MainTable'[Rejected by]) = "Blank", 0,
    SelectedField = NAMEOF('MainTable'[Created by]) && SELECTEDVALUE('MainTable'[Created by]) = "Blank", 0,
    1
)

     Then filter the visual with ShowRows=1 to remove Blank value:

    Result for your reference:



    Best regards,

    Joyce

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

2 Replies

  • non23's avatar
    non23
    Helper I
    1 year ago

    I have managed to find a partial solution by following this link.

    Unfortunately, I'm having issues with the Total as it's giving total of everything instead of the displayed values only. 

    Any help on the total issue would be appreciated!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi non23, 

       

      Please check the following mesuare:

      ShowRows = 
VAR SelectedField = SELECTEDVALUE(Parameter[Parameter Fields]) 
RETURN
SWITCH(
    TRUE(),
    SelectedField = NAMEOF('MainTable'[Approver]) && SELECTEDVALUE('MainTable'[Approver]) = "Blank", 0,
    SelectedField = NAMEOF('MainTable'[Rejected by]) && SELECTEDVALUE('MainTable'[Rejected by]) = "Blank", 0,
    SelectedField = NAMEOF('MainTable'[Created by]) && SELECTEDVALUE('MainTable'[Created by]) = "Blank", 0,
    1
)

       Then filter the visual with ShowRows=1 to remove Blank value:

      Result for your reference:



      Best regards,

      Joyce

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