In this blog, we will be seeing how we can create Dynamic Title in Power BI.
I have created a Clustered Column Chart which is showing Total Sales by Month and Year Slicer using random data as shown below.
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.
Select the Clustered Column Chart. Go to the General in Format Pane. In that select Conditional Formatting in Title as shown below.
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.