Forum Discussion
Dynamic names in field parameters (Selectedvalue)
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
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
| 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)
}
Hi,
I had something similar but look it shows year () and not year (2022) for example. It looks like selected year gets ignored and that was my issue too.
SELECTEDVALUE('Calendar (Posting Date)'[Year])-1 resulted in ' -1'
Kind regards,
RemcoHi Remco, that's correct.
It shows Year () and not Year (2022)That's unfortunately my issue, I would love the year to be shown, but as far as I am aware that is not possible to this date.
Ovo je veoma korisno! Puno ti hvala!!
