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

noverkamp's avatar
noverkamp
Frequent Visitor
3 years ago

Hi Remco, that's correct.
It shows Year () and not Year (2022)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      - is the OT_Year table joined or disconnected?  If it is joined then you don't need the dynamic field parameter.

       

       

       

      - if you expect the user to always select exactly one year then make the slicer single select.

      • noverkamp's avatar
        noverkamp
        Frequent Visitor
        3 years ago

        The data is an simple example. In my model I've several fields, so I need the dynamic field parameter. The question is, is this possible with 'selectedvalue'?