In general the formatting ( column colours, display units, data label formats ) in a Power BI report are fixed for the end user. How can we give end users the ability to format aspects of the visuals to suit their needs?

In this session, we look at making use of dynamic format strings and conditional formatting in Power BI, to allow end users to change the formatting of visuals. We begin with the basic concepts of dynamic format strings, which allow for the customisation of displayed data based on context and user interactions. Attendees will then learn how to apply these strings in reports to enhance the readability of data visuals.

Moving onto the use of conditional formatting rules and expressions to change the colours of data points within visuals. We also demonstrate combining dynamic format strings with conditional formatting to give end users significant flexibility in what to display in visuals.

By the end of this session, participants will have a comprehensive understanding of how to leverage these features and include them for their report end users.

Target audience = Intermediate Power BI users
Session Duration = 50 - 60 mins
Presented virtually to user groups in UK, Romania and Sweden
Future in-person and virtual sessions booked in for 2025
Previous session link https://www.youtube.com/watch?v=Ri1uVWwtLzc