Forum Discussion

snaraya's avatar
snaraya
Icon for Helper II rankHelper II
3 years ago
Solved

Values need to be changed as per multiple slicer selection

Hi Everyone,   I need the line in chart to change as per multiple slicer selections.I am using line and stacked column chart. X axis will have count of Classification . now i have removed in the gr...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi snaraya 
    Please try

    Test 2021 =
VAR Year2021 =
    SELECTEDVALUE ( 'Calendar'[Year] ) = 2021
VAR SelectedBU =
    SELECTEDVALUE ( vw_dart_fte[New BU] )
RETURN
    IF (
        Year2021,
        IF (
            ISFILTERED ( vw_dart_lta[classification] ),
            SWITCH (
                SelectedBU,
                "AA", 0.31,
                "CC", 0.31,
                "CA", 0.38,
                "GF", 0.15,
                0.27
            ),
            SWITCH (
                SelectedBU,
                "AA", 0.85,
                "CC", 0.63,
                "CA", 0.86,
                "GF", 0.35,
                0.66
            )
        )
    )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi snaraya 
Please try

Test 2021 =
VAR Year2021 =
    SELECTEDVALUE ( 'Calendar'[Year] ) = 2021
VAR SelectedBU =
    SELECTEDVALUE ( vw_dart_fte[New BU] )
RETURN
    IF (
        Year2021,
        IF (
            ISFILTERED ( vw_dart_lta[classification] ),
            SWITCH (
                SelectedBU,
                "AA", 0.31,
                "CC", 0.31,
                "CA", 0.38,
                "GF", 0.15,
                0.27
            ),
            SWITCH (
                SelectedBU,
                "AA", 0.85,
                "CC", 0.63,
                "CA", 0.86,
                "GF", 0.35,
                0.66
            )
        )
    )
  • snaraya's avatar
    snaraya
    Icon for Helper II rankHelper II
    3 years ago

    tamerj1 Thankyou so much.Worked perfectly fine