Forum Discussion

natasha519's avatar
natasha519
Helper II
4 years ago
Solved

Dynamic Text

I am trying to use the dynamic text value feature in Power BI but am unable to get it to work since I am using 2 different columns.    I have one column with various timeframes (Jan-Feb, Feb-Mar) a...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi natasha519 ,

    I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below, the displayed text will be dynamic base on the slicer selection.

    Dynamic Text = 
CONCATENATEX (
    FILTER ( 'Table', 'Table'[current?] = SELECTEDVALUE ( 'Table'[current?] ) ),
    'Table'[timeframes],
    ",",
    'Table'[timeframes]
)

    If the above one is not what you want, please provide some sample data(exclude sensitive data) and your expected result with backend logic and special examples. Thank you.

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi natasha519 ,

I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below, the displayed text will be dynamic base on the slicer selection.

Dynamic Text = 
CONCATENATEX (
    FILTER ( 'Table', 'Table'[current?] = SELECTEDVALUE ( 'Table'[current?] ) ),
    'Table'[timeframes],
    ",",
    'Table'[timeframes]
)

If the above one is not what you want, please provide some sample data(exclude sensitive data) and your expected result with backend logic and special examples. Thank you.

Best Regards