Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
Tips and Tricks
noverkamp's avatar
noverkamp
Frequent Visitor
3 years ago

I've the same problem. Do you already have a solution?

    • noverkamp's avatar
      noverkamp
      Frequent Visitor
      3 years ago
      YearLineEUR
      2022A10
      2022B20
      2022C25
      2023A14
      2023D69
      2023F50


      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)
}

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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,
        Remco