Dynamic change in X Axis

Hi singhal14

Here's one idea of how it can be done using a bridging table.

Could well be other ways of handling this :)

Dummy Power BI model here.

1. Assuming you have Region and Year lookup tables, create a RegionYear table which is the cross product of Region & Year tables.
2. Duplicate each row of RegionYear and add an Axis Dimension column which is "Region" for half the rows and  "Year" for the other half, and an Axis Value column which is the Region or Year value for each row (depending on the Axis Dimension value).
3. Relate Year and Region to RegionYear using inactive bidirectional relationships:
   
4. Create an Axis Dimension Selected measure to harvest the value of Axis Dimension. Something equivalent to this (this guards against multiple selection):
   

   Axis Dimension Selected = 
   IF (
       ISFILTERED ( RegionYear[Axis Dimension] ),
       IF (
           CALCULATE ( HASONEVALUE ( RegionYear[Axis Dimension] ), ALLSELECTED () ),
           VALUES ( RegionYear[Axis Dimension] )
       )
   )

5. Create a Sales Amount Flexible Axis measure like this (assuming Sales Amount is the normal measure):
   

   Sales Amount Flexible Axis = 
   IF (
       NOT ( ISBLANK ( [Axis Dimension Selected] ) ),
       SWITCH (
           [Axis Dimension Selected],
           "Region",
           CALCULATE (
               [Sales Amount],
               USERELATIONSHIP ( RegionYear[Region], Region[Region] )
           ),
           "Year",
           CALCULATE (
               [Sales Amount],
               USERELATIONSHIP ( RegionYear[Year], 'Year'[Year] )
           )
       )
   )

6. Then you can create visualizations using RegionYear[Axis Value] and [Sales Amount Flexible Axis]