Dynamic and conditional text content in reports

Hey everyone!

We’re creating a report that will be sent out to clients containing all of their relevant information. The report uses data from Dataverse to populate various visuals.

Our main goal at the moment is to dynamically change the content of a paragraph depending on the filters that are being used. The summarize function doesn’t work for our needs as we cannot change any text or wording. We are trying to make use of the dynamic value to show the relevant data but it doesn’t provide the right answer or gives us irrelevant data.

What would be the best way to dynamically change the content depending on certain conditions? E.g. value X is higher than Value Y or Highest from Column1 where column2 = X and column3 = Y.

Many thanks!