Forum Discussion

SJain's avatar
SJain
Microsoft Employee
10 years ago

Dynamic Titles

I'm working on a reporting feature using Power BI.  How can I make dynamic titles for my charts which are dependent on the filters applied only to that chart itself and should not change on selecting...
Need Help
Tutorial Requests
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

SJain

 

There's no straightforward way to get a dynamic title, however a workaround with a Card visual and a measure can work.

title = "sales for the cities "&CONCATENATEX(data,data[City],",")



 

To make the slicer work specifically for the table, disable the interactions between the slicer and other Visuals.

RenuKshirsagar's avatar
RenuKshirsagar
Advocate II
9 years ago

Hey Eric_Zhang,

       Your suggested answer works but when the Card visual is selected and the measure displaying the title is dragged, it displays  all the Slicer values even when no value is selected.

 

Example(considering your previous post) :

                                                                      Sales for the cities London,New York,Paris

gets displayed even when no value is selected. Is there any way to erase that off initially that could be included in the dax formula.

So that it appears blank at first.

 

Thanks