How to get Dynamic X-Axis Title based on Slicer Selection

[sagarsahoo_123]

Hi Team,

Need your support to resolve to display Dynamic X axis Title based on Slicer selection.

Requirement:- I have a slicer with Input column having two values like Nippon and Digi ACT. 

If i select Nippon, then in the X axis of Matrix Table it will display title as "Nippon Cumulative Hours"

If i select DigiACT, then in the X axis of Matrix Table it will display title as "DigiACT Average Hours"

If there is no selection or all selection , then in Matrix X axis it would display "Input Hours". Below given image for better understanding on the requirement.

Regards,

Sagar

[Avantika-Thakur]

Hi @sagarsahoo_123 ,

Currently we don't have the Fx option to apply a dynamic measure in the X-axis title available as part of visual formatting.

But you can create a measure = If ( Slicer ="Nippon","Nippon Cumulative Hours", If ( Slicer = "DigiACT","DigiACT Average Hours","Input Hours"))
and put this measure in a text box/card visual below the x-axis and it will act as a dynamic x-axis title.

Hope this helps!

Please accept the solution if this answers your query.

Thanks,

Avantika

[sagarsahoo_123]

Hello @Avantika-Thakur ,

I am gettig this error  while creating measure for this.

Please suggest if anything i am doing wrong here.

Regards,

Sagar

[Avantika-Thakur · Accepted solution]

Hi @sagarsahoo_123 ,

Can you try replacing Slicer in the Measure formula with SELECTEDVALUE(Slicer) and then try implementing it -
measure = If ( Selectedvalue(Slicer)="Nippon","Nippon Cumulative Hours", If ( SelectedValue(Slicer) = "DigiACT","DigiACT Average Hours","Input Hours"))

[sagarsahoo_123]

Hi @Avantika-Thakur ,

Thanks a lot for your quick support.

Regards,

Sagar