Forum Discussion

aamir200's avatar
aamir200
Frequent Visitor
3 years ago

how to show Custom text for parameter table

Hi All
 
I need help or suggest on below which I am stuck. It will be great if you can help on that and what will be dax for that

Custom text for parameter table
yesterday

I have created a table with fields parameter and using this in a slicer.

DAX 

Tabular Options - Summary = {
    ("vs LY"NAMEOF('Measure Folders'[Value Options formatted ( Summary )]), 0),
    ("Selected Perspective"NAMEOF('Measure Folders'[Selected Perspective]), 1),
    ("LY Actuals"NAMEOF('Measure Folders'[LY]), 2),
    ("vs AOP"NAMEOF('Measure Folders'[Value Options formatted ( Summary )(AOP)]), 3),
    ("AOP Actuals"NAMEOF('Measure Folders'[AOP]), 4)
}
Now I want to change the title based on user selection. Like in the "vs LY", I want to show "vs 2022" when user selects year 2023 from fact table. Is it possible?