Dynamic Changinng column Name in Table Viz

[kamalAnalyst]

I have created two measure current year sales and previous year Sales and I have year Slicer 

I have created table Customer wise current year and previous year sales 

What I want is 
When I select year then current year column name should show as selected year and previous year as (year - 1) eg year = 2023 then previous year = 2022

But If I dont select any year then It should give me only one column of overall sales customer wise and also If I select start year ie First Year then There wont be any Previous Year Data then should get only one column of current year 

??
Please help me in this since stuck since 2 days and there is presentation in 10 Days ....

[samratpbi · Accepted solution]

Hi,

its a bit tricky, however you can achieve that with few measures.
First, I created a sample table like below:

Then created below measures:

Total Sales = SUM(DynCol[Sales])

Total Sales Prev Yr =

CALCULATE(

    [Total Sales],

    DynCol[Year] = SELECTEDVALUE(DynCol[Year]) - 1

)

Then create a slicer on year column and put values into a matrix visual

Now, for your column header, create 3 more measures:

Current Year =

IF(

    NOT(ISFILTERED(DynCol[Year])),

    "Overall",

    SELECTEDVALUE(DynCol[Year])

)

MinYear =

CALCULATE(

    MIN(DynCol[Year]),

    ALL(DynCol)

)

Prev Year =

SWITCH(

    TRUE(),

    NOT(ISFILTERED(DynCol[Year]))," ",

    SELECTEDVALUE(DynCol[Year]) = [MinYear]," ",

    SELECTEDVALUE(DynCol[Year]) - 1

)

then MinYear is a measure to be used iin Prev Year measure.

Now, put the current year and prev year measures into card visuals and put on top of the columns.

It would look like below:

When nothing selected:

When 2022 selected:

when 2023 selected:

If this resolves your problem, then please mark it as Solution, Thanks!