Forum Discussion

SJain's avatar
SJain
Icon for Microsoft Employee rankMicrosoft 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
michaelswisher's avatar
michaelswisher
Icon for Advocate I rankAdvocate 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
Icon for Advocate II rankAdvocate 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