Dynamic Commentary In Power BI - Excelerator BI

Skip to content

Search Articles

Search for:

Blog Categories

Blog Categories Select Category Advanced (13) ALL (8) API (1) Beginners (87) BI Strategy (2) CALCULATE (13) Calculation Groups (3) COVID (7) Custom Visuals (3) Data Modelling (5) Dataflows (3) DAX (74) DAX Queries (11) DAX Studio (18) Direct Query (1) Excel (38) External Tools (1) FILTER (10) Flow (2) How to (217) InfoRiver (5) Intermediate (100) Job Opportunities (1) Learn to Write DAX (8) Learning Resource (190) M Language (7) MDIS (6) Miscellaneous (7) Mobile BI (1) Opinion (11) PASS BA Conference (10) PASS SQL Saturday (2) Performance (2) Power Automate (1) Power BI (157) Power BI Desktop (136) Power BI User Group (5) Power Platform (1) Power Query (96) PowerPivot (78) PQFL (5) Premium (2) PUG (2) Reports (15) SharePoint (5) Skillwave (2) SQL (6) SSAS (5) SSRS (1) SUMX (8) Tabular Editor (12) TechEd 2014 (4) Time Intelligence (6) Tools (19) Training (6) Training Videos (8) Uncategorized (10) VALUES (3) Variables (2) VBA (8) Visuals (15) Webinar (1)

Archives

Archives Select Month November 2025 (1) July 2025 (1) May 2025 (1) July 2024 (1) June 2024 (1) March 2024 (2) February 2024 (1) December 2023 (1) November 2023 (1) June 2023 (1) May 2023 (1) April 2023 (1) March 2023 (3) November 2022 (3) October 2022 (4) September 2022 (3) August 2022 (3) July 2022 (1) May 2022 (2) April 2022 (2) March 2022 (2) February 2022 (2) January 2022 (1) December 2021 (2) November 2021 (1) October 2021 (2) September 2021 (5) August 2021 (4) July 2021 (5) June 2021 (3) May 2021 (3) April 2021 (2) March 2021 (6) February 2021 (2) January 2021 (2) December 2020 (2) November 2020 (4) October 2020 (4) September 2020 (4) August 2020 (4) July 2020 (4) June 2020 (3) May 2020 (4) April 2020 (6) March 2020 (4) February 2020 (3) January 2020 (2) November 2019 (3) October 2019 (4) September 2019 (4) August 2019 (4) July 2019 (4) June 2019 (4) May 2019 (5) April 2019 (3) March 2019 (4) February 2019 (2) January 2019 (4) December 2018 (3) November 2018 (6) October 2018 (4) September 2018 (2) August 2018 (5) July 2018 (6) June 2018 (4) May 2018 (4) April 2018 (2) March 2018 (2) February 2018 (2) January 2018 (4) December 2017 (4) November 2017 (2) October 2017 (3) September 2017 (2) August 2017 (4) July 2017 (2) June 2017 (5) May 2017 (3) April 2017 (4) March 2017 (4) February 2017 (4) January 2017 (4) December 2016 (3) November 2016 (7) October 2016 (5) August 2016 (5) July 2016 (5) June 2016 (4) May 2016 (4) April 2016 (4) March 2016 (5) February 2016 (4) January 2016 (3) December 2015 (5) November 2015 (5) October 2015 (3) September 2015 (5) August 2015 (4) July 2015 (4) June 2015 (1) May 2015 (2) April 2015 (6) March 2015 (5) February 2015 (6) December 2014 (3) November 2014 (4) September 2014 (2) August 2014 (1) July 2014 (1) June 2014 (1) May 2014 (8) April 2014 (3) March 2014 (3) February 2014 (1) Please select a valid form.

Demystifying DAX (Advanced DAX) Online Training

Start Here

Best learning resource for DAX and Power BI.

Power BI Online Training

Live Training Melbourne

Cart

Product Categories

• Live Instructor Led Training
  • LivePBI4BAOnline
• Consulting
  • Coaching and Help
• Miscellaneous

Today is another in my series where I am building out my COVID report for Australia. There are a few things I cover in the video today.  The main “new” concept is the dynamic commentary, but I also show you some more warts and all insider view of building a report.

Continuous Improvement

Firstly I needed to do some touch up work to the report I have been building to date. Over time I have discovered some things that need to change, and some of the look and feel of the report is not quite working for me. This is one of those reality things when you build out reports – what you build the first time around may not be what you actually settle on in the long run. I think it is good to understand this – that beautifully polished reports normally go through a journey from prototype to final quality product.  So I show a couple of things I do to make my report look better.

Dynamic Commentary

The second thing I cover today is how to create dynamic commentary in your reports. This is not something I have used before, so I am glad to be able to share the technique with you in this article.

Video

Download the workbook

A few people have been asking me for the workbook. You are welcome to a copy if you like, but be aware that you wont be able to refresh it because there are quite some source files that would need to be correctly downloaded and configured before the refresh will work.  But, you can still take a look at what I have built in case you are interested.  Just a word of warning, this workbook is a hobby of mine.  I have decided not to invest time going back and fixing some things that probably should be fixed in a production quality report.  Think of it a bit like the taps in the house of a plumber – they always leak, right?

Download the file

Post navigation ← Previous PostNext Post →

7 thoughts on “Dynamic Commentary in Power BI”

1. 

   Dynamic commentary in Power BI is a game-changer! It allows reports to update narrative insights based on filters, slicers, or user selections—making dashboards more interactive and insightful.

   Log in to Reply
2. 

   Dynamic commentary in Power BI is a game changer It allows reports to update narrative insights based on filters, slicers, or user selections making dashboards more interactive and insightful.

   Log in to Reply
3. 

   Hi Mat,

   Are you updating this report daily? It shows that the last data is of 29/10/2021.

   Thanks for such a great dashboard!

   Log in to Reply
   1. 

      My interest has waned and I am only doing it every now and then 🙂. I will do it later today so it is up to date

      Log in to Reply
4. 

   Thank you for this great info!

   Log in to Reply
5. 

   Thanks for sharing, Mat. Great tip, I have been wondering what those values in the text box is for as well. This is definitely a good use case for it.

   Would you have the tricks to put the commentary to summarize the Top 3 items as well? E.G. Rank 1 of XXX is YY value; Rank 2 of XXX is zz value, etc.

   I can figure out the way to fetch the first and the last rank, but cannot really crack it yet to fetch the value that is rank 2 :-/

   Log in to Reply
   1. 

      My guess is you could build a table using SUMMARIZE that contains the data you need, and then use that as a first parameter inside a CONCATENATEX to produce some text. Alternatively you could just write it out long hand in the text visual and use measures for each of the product names (1, 2, 3) etc.

      Log in to Reply

Leave a Comment Cancel Reply

You must be logged in to post a comment.

adroll_adv_id = "SL2RPW5XMVH4XEWMDBMJGV"; adroll_pix_id = "IGOZLB3K75HKRLOQVTGTEU"; adroll_version = "2.0"; adroll_current_page = "other"; adroll_currency = "AUD"; adroll_language = "en_AU";