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

 

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

4 Replies

  • Avantika-Thakur's avatar
    Avantika-Thakur
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

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