Scatter Plot to change X axis and y axis dynamically

[Anshenterprices]

Hi Team,

name	Category	DateRange	Value
ABC	A	Last Day	5
ABC	A	Last month	14
ABC	A	LAST QTD	10
ABC	A	Last Year	7
ABC	B	Last Day	4
ABC	B	Last month	2
ABC	B	LAST QTD	7
ABC	B	Last Year	8

Requirment:-
I have two slicer Name and category in the report
once i select any name(ABC) from the name slicer then in the scatter plot will display x axis and y axis value based on the x axis date range selection and y axis date range selection

eg. if user select ABC from the name slicer then in the scatter plot user can compare  x axis and y axis values based on the date range selection of x axis and y axis
thanks

[Anonymous]

Hi @Anshenterprices ,

About dynamic change in X Axis, please kindly refer to:

Solved: Dynamic change in X Axis - Microsoft Power BI Community

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.

[amitchandak]

@Anshenterprices , If you are using measure on the x and y axis measure slicer can help.

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

If one of them is categorical value, then you need to use a bookmark or unpivot

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M

[Anshenterprices]

@amitchandak can i get pbix for the same?