Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
naaatthh
Regular Visitor

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!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@naaatthh , Enable Q&A, and then you can use measures in the text box, Create measures to return values/text etc based on conditions.

refer: https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-add-text-and-shapes?tabs=p...

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@naaatthh , Enable Q&A, and then you can use measures in the text box, Create measures to return values/text etc based on conditions.

refer: https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-add-text-and-shapes?tabs=p...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.