Forum Discussion

lucadelicio's avatar
lucadelicio
Impactful Individual
1 year ago
Solved

Small multiples Parametric ON/OFF

 

Goodmorning everybody,

i need to do a porting from another BI system.
I need to create a chart and line visual with the switch on/off option on the small multiples.

This is the chart when the Small multiple is ON

 and this is the result that i need when the small multiple is OFF

I try to create a parameter field to put into the filter ON/OFF:

PAR Country = {
    ("ON", NAMEOF('kpi-EV'[COUNTRY]), 0)
    ,("OFF", BLANK(), 1)
}
but it works just only for the ON and get error for the OFF option.

Have you got some ideas?
Thank you everybody

  • After many hours of works i resolved immediately after publish the post -.-''

    This is the correct way to create the parameter fileds for switch OFF/ON the Small multiples!

    PAR Country = {
        ("ON", NAMEOF('kpi-EV'[COUNTRY]), 0)
        ,("OFF", TRUE(), 1)
    }

    Thank you anyway!

1 Reply

  • lucadelicio's avatar
    lucadelicio
    Impactful Individual

    After many hours of works i resolved immediately after publish the post -.-''

    This is the correct way to create the parameter fileds for switch OFF/ON the Small multiples!

    PAR Country = {
        ("ON", NAMEOF('kpi-EV'[COUNTRY]), 0)
        ,("OFF", TRUE(), 1)
    }

    Thank you anyway!