Dynamic Title of chart besed hyerarchy

[Ritaf]

Hi, 

I'm trying to create a dynamic chart title, which will be changed according to the hierarchy level' for example when it is Month the title will be " total XXXX by month" and if it day-mont "total zzz by day-month" etc.

I need to create a measure for it because my titles are not in English so the automatic titles of charts aren't helping me.

I tried to use functions as isinscope / isfiltered, but they didn't work because there is no filter context, the drill-down is not from one of the bars it is on chart level .
Is there is some way to create a measure like that?

Thank you,

Rita

[VahidDM]

Hi @Ritaf 

Can you create a sample of your report with a visual and share the PBIX file here?

Appreciate your Kudos✌️!!

[Ritaf]

Hi,
This is a standard model, I put it on Contoso Database, here:
https://drive.google.com/file/d/18VVnq6XKxDyQa18r1XXzBR6j1kSkdDeu/view?usp=sharing

[Greg_Deckler]

@Ritaf This may give you some additional ideas on what you can do with your dynamic title:

The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community

[aj1973]

Hi @Ritaf Rita,

Try this 

MY_testTitle = IF(SELECTEDVALUE('Calendar'[DayOfMonth]),"Day Title", IF(SELECTEDVALUE('Calendar'[Month No]),"Month Title" , "Year Title"))

But first you will need to add Month No column to the calendar Table

[Ritaf]

Thank you for your response , but i need the date slicer as is ...if i need to choose between it and title...the slicer is more important for my users

[aj1973]

Hi Rita

Try to watch this video, it might help

https://www.youtube.com/watch?v=XXv13mkjV2Y

[v-easonf-msft]

Hi, @Ritaf 

As a workaround, you can consider changing the model language setting and restarting the application, then re-creating the report.

Best Regards,
Community Support Team _ Eason

[Ritaf]

Changing model language is very problematic, Hebrew has a lot of sides issues ...so it doesn't work well with numbers. I need a dax solution, otherwise, I will stay with my static title, it is not so dramatic.   I just was sure that this is not an insurmountable problem.

[v-easonf-msft]

Hi,  @Ritaf 

I'm afraid this is difficult to implement . It is not possible to use functions to identify the current hierarchy level in a chart without additional slicers.

Best Regards,
Community Support Team _ Eason