dynamically chang the title of a bar chart based on selections made within the same chart

[MB123]

Hi,

I'm currently working on a scenario where I need to dynamically change the title of a bar chart based on user interaction. I have a bar chart that displays test cases automated on a week-by-week basis. When a user clicks on a specific week within the same chart, I want the chart title to update accordingly, showing something like "Test Cases Automated in Week 1" if Week 1 is selected.

(Not Using Slicer selection )

To achieve this, I've written the following DAX measure named WeekDynamic:

DAX...........
WeekDynamic =
VAR SelectedWeek =
IF(
ISFILTERED('Calendar'[WeekOfMonth]),
"Test Cases Automated in Week " & SELECTEDVALUE('Calendar'[WeekOfMonth]),
"Test Cases Automated"
)
RETURN
SelectedWeek
I've tried using this measure in the chart title settings, but it doesn't seem to update as expected when I click on different weeks. I also attempted another approach: "Test Cases Automated" & SELECTEDVALUE('Calendar'[WeekOfMonth]), but encountered similar issues.

Could anyone please assist me in identifying what might be causing this issue?

[Anonymous]

Hi @MB123 ,

I think you're on the right path, but implementing it seems to necessitate the use of a slicer. You could make an attempt to filter by filter and silcer respectively and see what isfilter returns.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.