Switching to Dynamic X Axis based on filter Selection

[Balaraju]

Hi All, 

Hope all are doing good.

I have one requirement based on the filter selection I want the X-Axis should be changed dynamically.

i.e I have data with different countries along with Key accounts, dealer, region, and sales. Here all countries are showing Key accounts under the key accounts column but Indonesia Instead of maintaining a Key account number under the key account column they are maintaining Region and Dealer column they are maintaining Key account. you can see the screenshot below.

because of this data, the visuals show like the below screenshots.

when the user selects Indonesia from the filter instead of showing key accounts it is showing region cause Indonesia has a region in the key account column.

Now my actual requirement is I want to see dealers in X- axis, when I select Indonesia country rest of the countries need to show key account data because Indonesia has key accounts in the dealer column. see below screen shot.

Data:

Thanks,

Bala.

[ddpl · Accepted solution]

@Balaraju try this

Create new Calculated Column as per below:

Final Keys = IF('Table'[Country] = "Indonesia",'Table'[Dealer],'Table'[Key])