Forum Discussion
Scatter Plot-Dynamic X axis title and Y axis title based on slicer selection
Hi all,
I would like to know is there any possibility to dynamically change x-axis title and y axis title of scatter plot
based on slicer selection.
For eg,
I have a slicer for - Sales vs Customer & Order vs quantity.so when I select Sales vs Customer in the slicer, I want scatter plot x axis title to be customer and y axis title to be Sales ,similar way when I Select Order vs Quantity,I want the axis title to change dynamically as Order in Y axis and Quantity in X axis.
When Order vs Quantity is selected
When Sales vs Customer is selected
- Anonymous5 years ago
Hi Shanmathee ,
I found this simliar post which might be helpful to solve your issue.
Here's one idea of how it can be done using a bridging table.
Please kindly refer to:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- Pragati11
Super User
Hi Shanmathee ,
There is already an existing thread for this issue:
https://community.powerbi.com/t5/Desktop/Dynamic-Title-based-on-3-slicers/m-p/1484169
Thanks,
Pragati
- amitchandak
Super User
Shanmathee , same like problem same a measure slicer. Refer
- AnonymousNot applicable
Hi Shanmathee ,
I found this simliar post which might be helpful to solve your issue.
Here's one idea of how it can be done using a bridging table.
Please kindly refer to:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi Shanmathee ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Stephen Tao- ShanmatheeFrequent Visitor
Hi Anonymous
I am looking for something like
Based on slicer selection -I wanted the Axis title(not the chart title) to change dynamically in Scatter plot .
Thanks amitchandak Pragati11 ,Your suggestions were really good but it was not my requirement since i am trying for a dynamic Axis title change, not the Visual Title nor the values in the Axis.
To add clarity,When I select Sales vs Customer,I want my Y axis title to be Sales ,& X axis title to be Customer.
Any Ideas on this welcomed.Thanks in Advance.