Dynamic Title in Power BI

Making your reports/dashboards more dynamic requires you to be attentive to small details. In my last post I discussed about how you can create a dynamic table with a slicer having multiple dimensions. In this post I want to talk about how to improve your dynamic tables and charts in reports. 

If you want to link the title of your chart on report page to a filter/slicer on the page, you can do so in many different ways. Lets discuss a few of them now

Here you have to make a title measure with one of the following options:

Option 1: If you want to see Sales by cities - connect you City filter as follows:

Title = "sales for the cities "&CONCATENATEX(data,data[City],",") Option 2: You can use SelectedValue function: Title = SELECTEDVALUE("Total Sales and GM by:", 'Dimension[dimension])

Option 3: You can use Concatenatex to make allow reading multiple selections (Thanks to 

Title =

"Sales Amount for "     & CONCATENATEX (                             VALUES( 'Dimension'[Dimension] ),                          ''Dimension [Dimension],                            ", "         )

Option 4: You can use HasOneValue. The measure uses the “HASONEVALUE” function to see if only one date is filtered in the DateTable. If only one date is selected it returns the dynamic title otherwise it returns a message that basically tells the user to select a single date.

    Title = 
    If (
        HASONEVALUE ( DATETable[Datekey]),
        "Sales as on : "& [Datekey], 
        "Please select one value"
         )


Thus, you will be able to have a dynamic filter for your charts/visualization.
After selecting an option you will have a measure which you can simply drag into a card visual or better multi-card visual. Multi-Card visual is left aligned by default, so you would not have any problem when you change the value in filter.

Thank you :)