Dax for the Default Chart Title

[sd_kevin]

Hi, 

I am trying to dynamically change the Bar Chart title based on users selection and level of Drill Down/Up, Show Next Level or Expand to next level that is selected. I can dynamically change the portion of the title as it relates to the content of the data but I need help keeping with is keeping the same logic that the defualt chart title uses.

For example, with the default chart title (I have a date hierarchy with just Year & Month) starts with the "...by Year".

- when user clicks on show next level it'll show "...by Month".

- when user clicks on expand down to next level it shows "...by Year and Month".

What is the Dax code to replicate this logic in the title?

Thank you!

Kevin

[amitchandak]

@sd_kevin , I doubt that. We have isinscope, but that will only work for bars(you can try)

Another option is to try field parameters.  Selected all or unselect all it will work like a normal bar. but it will change the title Field Parameters- One solution for Measure Dimension slicer: https://youtu.be/lqF3Wa1FllE?t=70 

[sd_kevin]

Thank you for your response. That is unfortunate that the end users cannot mimic the logic of the default dynamic title.