Forum Discussion
Dynamic names in field parameters (Selectedvalue)
I've the same problem. Do you already have a solution?
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)
Ovo je veoma korisno! Puno ti hvala!!
