In this video, Patrick builds on a blog post from Scott Senkeresty to dynamically change the axis of your visual within Power BI. This uses a combination of Power Query and DAX.

Chris Cook – @Finalyst89
Scott Senkeresty – @ScottSenkeresty

Dynamically changing chart axis
http://tinylizard.com/dynamically-changing-chart-axis/