How to handle YoY change be 0 with only Year column?

[Anonymous]

Hi,

I have a Date table in the Russian language, while I do not want to Дата'Год' name. Instead, I want to see only the "Year" name in the visual. To do this I duplicated the date column and extracted the year. Now I have only Year columns with years only. I replaced the year in the visual with the new column of "Year" and all YoY became 0. Can I change the name of the visual only without the above-mentioned steps? if not how can I handle YoY change 0's?

Before with the original date column:

after with extracted year column

[jppv20]

@Anonymous can you provide some example input data and the current YoY calculations?

[Anonymous]

Trade_turnover YoY% =

IF(

    ISFILTERED('Дата'[Дата]),

    ERROR("Быстрые меры временной аналитики можно группировать и фильтровать только по иерархии дат или столбцу первичных дат из Power BI."),

    VAR __PREV_YEAR =

        CALCULATE(

            [Trade_turnover],

            DATEADD('Дата'[Дата].[Date], -1, YEAR)

        )

    RETURN

        DIVIDE([Trade_turnover] - __PREV_YEAR, __PREV_YEAR)

)

[jppv20]

Hi @Anonymous ,

Do you just want to change the name of the column in the visual?

In that case you can simply click on the visual and under "Values", choose Rename for this visual:

If I answered your question, please mark it as a solution to help other members find it more quickly.

[Anonymous]

thanks for your quick response, but Data hierarchy does not have rename option in the visual