Forum Discussion

Arjun_reddy's avatar
Arjun_reddy
Helper I
3 years ago
Solved

DAX

Hi Community team,

 

I am facing an issue with the bar chart, I have created one measure when i am using that into bar chart all the data labels are showing same on bars, I don't want see that, I want to see slipted on pack type

VAR selectedyear=SELECTEDVALUE(Sunchips_MP[YEAR])
VAR MAXPERIOD=MAX(Sunchips_MP[PERIOD])
VAR CY =  CALCULATE(
        SUM('Sunchips_MP'[TOTAL OCCASIONS]),
        FILTER(
            ALL(Sunchips_MP),
            'Sunchips_MP'[YEAR] = SelectedYear && Sunchips_MP[PERIOD] <= MAXPERIOD && Sunchips_MP[BRAND MIX]="SUNCHIPS"
        )
    )

VAR CurrentYear = MAX(Sunchips_MP[YEAR])
VAR PreYear = CurrentYear-1
Var PY = CALCULATE(
        SUM('Sunchips_MP'[TOTAL OCCASIONS]),
        FILTER(
        ALL(Sunchips_MP),
            'Sunchips_MP'[YEAR] = PreYear && Sunchips_MP[PERIOD] <= MAXPERIOD && Sunchips_MP[BRAND MIX]="SUNCHIPS"
        )
    )
VAR YEAR_GROWTHRATE=(CY-PY)/PY
RETURN YEAR_GROWTHRATE
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Arjun_reddy ,

     

    I think you create this visual by [Pack] column in X axis and [YoY Growth Rate] in value field.

    Your issue should be caused by ALL() function, you need to add [Pack] column into filter field.

    Please try code as below.

    YOY Growth Rate =
VAR selectedyear =
    SELECTEDVALUE ( Sunchips_MP[YEAR] )
VAR MAXPERIOD =
    MAX ( Sunchips_MP[PERIOD] )
VAR CY =
    CALCULATE (
        SUM ( 'Sunchips_MP'[TOTAL OCCASIONS] ),
        FILTER (
            ALLEXCEPT ( Sunchips_MP, Sunchips_MP[Pack] ),
            'Sunchips_MP'[YEAR] = SelectedYear
                && Sunchips_MP[PERIOD] <= MAXPERIOD
                && Sunchips_MP[BRAND MIX] = "SUNCHIPS"
        )
    )
VAR CurrentYear =
    MAX ( Sunchips_MP[YEAR] )
VAR PreYear = CurrentYear - 1
VAR PY =
    CALCULATE (
        SUM ( 'Sunchips_MP'[TOTAL OCCASIONS] ),
        FILTER (
            ALLEXCEPT ( Sunchips_MP, Sunchips_MP[Pack] ),
            'Sunchips_MP'[YEAR] = PreYear
                && Sunchips_MP[PERIOD] <= MAXPERIOD
                && Sunchips_MP[BRAND MIX] = "SUNCHIPS"
        )
    )
VAR YEAR_GROWTHRATE = ( CY - PY ) / PY
RETURN
    YEAR_GROWTHRATE

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
    https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
    Please show the expected outcome based on the sample data you provided.

    https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Arjun_reddy ,

     

    I think you create this visual by [Pack] column in X axis and [YoY Growth Rate] in value field.

    Your issue should be caused by ALL() function, you need to add [Pack] column into filter field.

    Please try code as below.

    YOY Growth Rate =
VAR selectedyear =
    SELECTEDVALUE ( Sunchips_MP[YEAR] )
VAR MAXPERIOD =
    MAX ( Sunchips_MP[PERIOD] )
VAR CY =
    CALCULATE (
        SUM ( 'Sunchips_MP'[TOTAL OCCASIONS] ),
        FILTER (
            ALLEXCEPT ( Sunchips_MP, Sunchips_MP[Pack] ),
            'Sunchips_MP'[YEAR] = SelectedYear
                && Sunchips_MP[PERIOD] <= MAXPERIOD
                && Sunchips_MP[BRAND MIX] = "SUNCHIPS"
        )
    )
VAR CurrentYear =
    MAX ( Sunchips_MP[YEAR] )
VAR PreYear = CurrentYear - 1
VAR PY =
    CALCULATE (
        SUM ( 'Sunchips_MP'[TOTAL OCCASIONS] ),
        FILTER (
            ALLEXCEPT ( Sunchips_MP, Sunchips_MP[Pack] ),
            'Sunchips_MP'[YEAR] = PreYear
                && Sunchips_MP[PERIOD] <= MAXPERIOD
                && Sunchips_MP[BRAND MIX] = "SUNCHIPS"
        )
    )
VAR YEAR_GROWTHRATE = ( CY - PY ) / PY
RETURN
    YEAR_GROWTHRATE

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.