Forum Discussion

DiePic's avatar
DiePic
Icon for Resolver II rankResolver II
2 years ago

dynamically change title in drill down charts

Hi all,
reading a lot of post about the subject of this post, I've find a measure that's working:

DinamicTitle =
    SWITCH (
      TRUE,
      ISINSCOPE ( Articoli[Descrizione] ), "Descrizione",
      ISINSCOPE ( Articoli[Dimensione 2] ), 'Dimension Names'[First Item Dimension 2], 
      ISINSCOPE ( Articoli[Dimensione 1] ), 'Dimension Names'[First Item Dimension 1], 
      "other"
    )
and this works inside a matrix

I find all the names that I need for my report.
But in a measure and in the chart this is not working, retrieve in any case  the last option "other".
There is someone that can help me with this "Dinamic Title"?

 

thanks in advance

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    2 years ago

    DiePic I don't think that measure will work in this case because there is no context of the column name on the title. If you put the same measure in the card visual, you will get the same value "other". Reason it works in the matrix visual because there are columns in the hierarchy. 

    • DiePic's avatar
      DiePic
      Icon for Resolver II rankResolver II
      2 years ago

      thanks for reply parry2k ,
      do you have some suggestion (or some link where I can study it) on how I can do to have this dinamic title on chart?