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
RenuKshirsagar's avatar
RenuKshirsagar
Advocate II
8 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

michaelswisher's avatar
michaelswisher
Advocate I
8 years ago

Hi RenuKshirsagar,

 

Wrap the CONCATENATEX statement with an IF statement, such as:

 

IF(NOT(ISFILTERED(Products[Subcategory])),"All",  ....

 

then your Concatenatex statement.  Substitute something more appropriate for "All".  You could also add another IF statement to count the number of items selected, and use a more specific description telling the user "> 6 months selected", for example.

 

Hope this makes sense,

Michael

  • RenuKshirsagar's avatar
    RenuKshirsagar
    Advocate II
    8 years ago

    Hey michaelswisher,

                    I already found an answer for the mentioned question but still thanks for your response. I will definitely try your suggested solution.

    Thanks