Dynamic Text

[natasha519]

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 · Accepted solution]

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]

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