Forum Discussion

Jskdlai23's avatar
Jskdlai23
Regular Visitor
1 year ago
Solved

How to Dynamically Set Field Parameter Title Based on a Slicer in DAX?

Hi everyone,   I'm working on a Power BI report and trying to set the title of a field parameter dynamically using a SELECTEDVALUE. The goal is to make the column title in a matrix update based on ...
Need Help
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    Hello, Jskdlai23 
    you can't use SELECTEDVALUE for Field Parameter in its pure form.

    There's a quick workaround tho:
    Field parameter as it is:

    Create new calculated column inside the field parameter table like this, basically referencing the first column

     

    Then use SELECTEDVALUE for newly created column that mirrors the original one.

eva_t1984's avatar
eva_t1984
Frequent Visitor
1 year ago

vojtechsima 

Can you share an example of how you continuen with the selectedvaule for the new created column? 

I have 2 slicers in my report "Month" and "Year" and I want the measure to display YTD January 2025, YTD January 2024, YTD January 2023.... I am not quite sure how to continue, once I added the new calculated column within the field parameter. 

 

Thank you!

  • Element115's avatar
    Element115
    Icon for Memorable Member rankMemorable Member
    1 year ago

    Perhaps this might help:

     

     

     

     

    So, the Display slicer shows just a name. Depending on what the slicer selection is, this is returned by the SELECTEDVALUE() function inside a measure defined on the FieldSelector table.  The SWITCH() function simply decides which measure is called depending on the incoming name chosen in the slicer, like so: 

    show_selected_field = 
    SWITCH (
        SELECTEDVALUE ( 'FieldSelector'[MeasureName] ),
        "Velocity", 'TS_MEASURES'[TS_AVG_VELOCITYxHOUR],
        "Volume", 'TS_MEASURES'[TS_AVG_VOLxHOUR]
    )

     

    'TS_MEASURES' is just a dummy table that contains all my measures.  Measures have global scope within a report. In other words, if you define a measure on table T0, this measure is visible from any other table.  So, if one have a huge amount of tables and does not remember which measure is associated with with table, it is easier to find all measures if they are all centralized under one dummy table.