Forum Discussion
Dynamic names in field parameters (Selectedvalue)
Hi community, I am trying to get dynamic column names in my tables in a way that it always shows the Gross revenue for the selected year and the year before. I am using a field parameter and I ...
| Year | Line | EUR |
| 2022 | A | 10 |
| 2022 | B | 20 |
| 2022 | C | 25 |
| 2023 | A | 14 |
| 2023 | D | 69 |
| 2023 | F | 50 |
Fact table:
Dimension Table:
OT_Year =
DISTINCT(
SELECTCOLUMNS(
CALENDAR(
DATE(2022, 1, 1),
TODAY()
),
"Year", FORMAT(year([Date]), "0")
))
Visual:
Dynamic_parameter_field_EUR:
Dynamic_parameter_field_EUR =
VAR selected_year = SELECTEDVALUE(OT_Year[Year])
Return
{
("Year ("&selected_year&")", NAMEOF('Fact'[Measure_EUR]), 0)
}
Ovo je veoma korisno! Puno ti hvala!!
