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 "Blan...
"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.

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.