Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Jan 08, 2025
Solved

Field Parameter when used in filter pane not working for TOPN filters

Hi,   I have created a visual as below: Now I want to filter this visual by  bottom 10 worst performers Site Name by Variance parameter created. FYI the variance Field parameter table shown be...
  • SergeiBaklan's avatar
    Jan 09, 2025

    Excellove15 ,

    Composite key is not part of the model, it's unpacked in background query for visuals. Thus we need to return somehow parameter value into the model to apply it to filters.

    As variant we may create two measures.

    Selected Parameter =
    VAR SelectedParameter =
        SELECTCOLUMNS (
            SUMMARIZE ( 'Variance', 'Variance'[Parameter], 'Variance'[Parameter Fields] ),
            'Variance'[Parameter]
        )
    RETURN
        IF ( COUNTROWS ( SelectedParameter ) = 1, SelectedParameter )

    and

    Performance =
    SWITCH (
        TRUE,
        [Selected Parameter] = "Target Unit Variance", [Target Unit Variance],
        [Selected Parameter] = "Budget Unit Variance", [Budget Unit Variance],
        [Selected Parameter] = "Budget Cost Variance", [Budget Cost Variance],
        [Selected Parameter] = "Target Cost Variance", [Target Cost Variance],
        [Selected Parameter] = "Budget Carbon Variance", [Budget Carbon Variance],
        [Selected Parameter] = "Target Carbon Variance", [Target Carbon Variance],
        [Selected Parameter] = "Target Unit Variance (TimeSeries)", [Target Unit Variance (TimeSeries)],
        [Selected Parameter] = "Target Cost Variance (TimeSeries)", [Target Cost Variance (TimeSeries)],
        [Selected Parameter] = "Budget Unit Variance (TimeSeries)", [Budget Unit Variance (TimeSeries)],
        [Selected Parameter] = "Budget Cost Variance (TimeSeries)", [Budget Cost Variance (TimeSeries)],
        [Selected Parameter] = "Budget Carbon Variance (TimeSeries)", [Budget Carbon Variance (TimeSeries)],
        [Selected Parameter] = "Target Carbon Variance (TimeSeries)", [Target Carbon Variance (TimeSeries)],
        0
    )

    and use them with visuals

    where

    Perhaps not good from maintenance point of view, but at least it works.

Resources