Forum Discussion

charonT's avatar
charonT
Helper I
2 years ago
Solved

Remove blank data after selecting the parameter slicer

Hi, I am a new user of Power BI and I might not have explained my issue clearly. I've set up a parameter that enables users to choose the column they want as the x-axis for a graph. However, there ar...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    charonT,

     

    Create a measure using the pattern below. The SWITCH function should have an entry for each column in your field parameter. Add this measure as a visual filter (greater than 0).

     

    Visual Filter =
VAR vSelectedParameter =
    SELECTCOLUMNS (
        SUMMARIZE ( 'Parameter', 'Parameter'[Parameter], 'Parameter'[Parameter Fields] ),
        "Parameter", 'Parameter'[Parameter]
    )
VAR vResult =
    SWITCH (
        vSelectedParameter,
        "ACTMEAN",
            SUMX (
                DimTable,
                VAR vColumn = DimTable[ACTMEAN]
                RETURN
                IF ( NOT ISBLANK ( vColumn ), 1 )
            ),
        "ACTONTRACK",
            SUMX (
                DimTable,
                VAR vColumn = DimTable[ACTONTRACK]
                RETURN
                IF ( NOT ISBLANK ( vColumn ), 1 )
            )
    )
RETURN
    vResult

     

DataInsights's avatar
DataInsights
Super User
2 years ago

charonT,

 

Create a measure using the pattern below. The SWITCH function should have an entry for each column in your field parameter. Add this measure as a visual filter (greater than 0).

 

Visual Filter =
VAR vSelectedParameter =
    SELECTCOLUMNS (
        SUMMARIZE ( 'Parameter', 'Parameter'[Parameter], 'Parameter'[Parameter Fields] ),
        "Parameter", 'Parameter'[Parameter]
    )
VAR vResult =
    SWITCH (
        vSelectedParameter,
        "ACTMEAN",
            SUMX (
                DimTable,
                VAR vColumn = DimTable[ACTMEAN]
                RETURN
                IF ( NOT ISBLANK ( vColumn ), 1 )
            ),
        "ACTONTRACK",
            SUMX (
                DimTable,
                VAR vColumn = DimTable[ACTONTRACK]
                RETURN
                IF ( NOT ISBLANK ( vColumn ), 1 )
            )
    )
RETURN
    vResult

 

charonT's avatar
charonT
Helper I
2 years ago

Thank you! It totally works!