Hi there, I often have this requirement from my clients, so I’d like to share it with you also. Basically, doing dynamic axis with dax enables you to solve complex cases easily. You need to have an axis table combining your axes and the make inactive relationships with your model and call them in your measures. This video explains this subject thoroughly:
