Dynamic Title In Power BI

  • Published
  • Posted in Power BI
  • Updated
  • 2 mins read
  • Tagged as

Hello readers, we all Microsoft releases monthly updates with cool and exciting features. In this blog we’ll see one of the cool features i.e., visuals with Dynamic Titles. We will also learn, how to create a visual with dynamic title based on slicer selection.

All the time we use DAX expressions to write business logics & calculate something. But in this article, you will come to know how DAX measures can be used to make our reports attractive.

Let’s understand this with an example, my report has sales data & I’ve Country slicer on top of my report.

Report View         Figure 1: Report View

Now, on the Modelling or Home ribbon, select New Measure.

Table Title = “Sales Record: ” & SELECTEDVALUE(‘Order'[State]) & “State”

Sales Record

Figure 2: DAX Expression

Now go to format setting of the visual and go to title & click on conditional formatting(fx) option.

Conditional Formatting
Figure 3: Conditional Formatting

In format by field value, select the measure that you’ve created & click on OK.

Dynamic Title

After clicking OK, your Dynamic Title for the selected visual is created.

Dynamic Title

As you can see, I’ve selected Alabama in state slicer & our title is changing as per our slicer selection. This is how one can create Dynamic Title.

I hope you find this blog useful. Thank you for reading.

Gaurav Lakhotia
Data Analyst
Addend Analytics

Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.