Forum Discussion

Nicki's avatar
Nicki
Helper III
8 years ago

Changed title dynamically in drill down charts

Hi ,

 

How  can we  change title of charts dynamically in drill down report?

 

 

Thank you in advance

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Often, you get rid of the default title and create a Measure and use a Card visualization like:

     

    m_Plants = IF(HASONEVALUE(tbl_Machines[Plant]),MAX(tbl_Machines[Plant]),CONCATENATEX(VALUES(tbl_Machines[Plant]),[Plant],", "))

    This dynamically changes the text of the card based upon how things are filtered. Will just depend on what you want to do. If you can supply some sample data and specifics around what you are trying to do, can provide more specific solution.

    • Nicki's avatar
      Nicki
      Helper III
      8 years ago

       

      Thanks Smoupre.  I am trying to do this:

      I have a chart and it has two or three  levels of  drill down. And also I have  a hierarchy with two values.

       X - axis is for the first chart is  "Date".

      The second chart is based on the first  value of hierarchy.("city")

      The third chart is based on the second  value of hierarchy.("country")

      I want to change title of  chart when I click on drill down feature and  go to  another chart.

      For example, The following titles will be in 3 charts respectively.

       "Total  Events  by"&" Date "

      "Total  Events by "& " City "  

      "Total  Events by "& " Country  "

      But the date,city and Country  are   in "shared axis" of chart.