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

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi natasha519 ,

 

As far as I can understand your question, you can add timeframes column in the visual and use  current timeframe as filter.

 

Thanks,

Samarth