Dynamic Title in Power BI

  • Published
  • Posted in Power BI
  • Updated
  • 1 min read
  • Tagged as

In this blog, we will be seeing how we can create Dynamic Title in Power BI.  

 Step 01: 

I have created a Clustered Column Chart which is showing Total Sales by Month and Year Slicer using random data as shown below. 

Step 02: 

Now, create a DAX –
Dynamic Title = “Total Sales for” & SELECTEDVALUE(‘Date'[Year], “All Months”) 


Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns the alternate result. 


SELECTEDVALUE(<columnName>[, <alternateResult>]) 

Step 03: 

Select the Clustered Column Chart. Go to the General in Format Pane. In that select Conditional Formatting in Title as shown below.  

Step 04: 

Then, the below pop-up screen will appear. Select the DAX which we have created and click on OK as shown below. 


Now, we are ready to use the Dynamic Title i.e., when we select the Year e.g., 2021. Then the title of the Clustered Column Chart will work according to the Dynamic Title DAX we have created as shown below. 


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.