Forum Discussion

sagarsahoo_123's avatar
sagarsahoo_123
Icon for Helper IV rankHelper IV
3 years ago
Solved

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

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 s...
Need Help
  • Avantika-Thakur's avatar
    Avantika-Thakur
    3 years ago

    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's avatar
sagarsahoo_123
Icon for Helper IV rankHelper IV
3 years ago

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's avatar
Avantika-Thakur
Icon for Solution Supplier rankSolution Supplier
3 years ago

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"))