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) and then another column which shows the current timeframe (0 or 1).

 

How can I pull just the text (timeframe) where the current timeframe = 1?

  • 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

2 Replies

  • 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

  • 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