topic Dynamic Text in DAX Commands and Tips

Dynamic Text

natasha519 — Wed, 05 Jan 2022 16:47:48 GMT

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?

Re: Dynamic Text

Samarth_18 — Wed, 05 Jan 2022 17:27:36 GMT

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

Re: Dynamic Text

Anonymous — Mon, 10 Jan 2022 08:33:00 GMT

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