Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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"))
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
Hello @Avantika-Thakur ,
I am gettig this error while creating measure for this.
Please suggest if anything i am doing wrong here.
Regards,
Sagar
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"))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |