topic Re: Dynamic X-axis on Column Chart based on selection in DAX Commands and Tips

Dynamic X-axis on Column Chart based on selection

eliasayyy — Mon, 01 May 2023 08:20:24 GMT

hello everyone i have 2 tables

product analysis and campaign analysis

i made a field parameter table including the measures from both product and campaign

some measures from product : "Adds to Cart " , "Checkouts" , "Revenues"

some measures from Campaign : "Bounces" , "Sessions"...

i added a slicer that will allow the user to select the measure they want to see

my goal is i want to know if its possible to have a dynamic x-axis that if the client selects "Add to Carts" measure on the slicer, the axis will show the products distribution while if they choose the "Bounces" measure on the slicer, they axis will shift to showing by campaign distribution

is this possible?

tamerj1 johnt75 amitchandak FreemanZ v-yueyunzh-msft

Re: Dynamic X-axis on Column Chart based on selection

tamerj1 — Mon, 01 May 2023 08:57:43 GMT

Hi eliasayyy
Probably can be done but you need to share a sample file.

Re: Dynamic X-axis on Column Chart based on selection

eliasayyy — Mon, 01 May 2023 09:04:58 GMT

i did it kinda, i made a new field parameter called "X-axis Paramter" and added the fields "Campaign" and "Product"

but since my fields parameter for the measures has 11 measures and order from 0 to 10

i had to do this

GA X-Axis Slicer = { ("Campaign", NAMEOF('Campaign Analysis'[Campaign]), 0), ("Campaign", NAMEOF('Campaign Analysis'[Campaign]), 1), ("Campaign", NAMEOF('Campaign Analysis'[Campaign]), 2), ("Campaign", NAMEOF('Campaign Analysis'[Campaign]), 3), ("Campaign", NAMEOF('Campaign Analysis'[Campaign]), 4), ("Campaign", NAMEOF('Campaign Analysis'[Campaign]), 5), ("Campaign", NAMEOF('Campaign Analysis'[Campaign]), 6), ("Product", NAMEOF('Product Analysis'[Product]), 7), ("Product", NAMEOF('Product Analysis'[Product]), 8), ("Product", NAMEOF('Product Analysis'[Product]), 9), ("Product", NAMEOF('Product Analysis'[Product]), 10) }

then make a relationship between order column of x-axis and order column of measure parameter.

so now when i select the measure from the slicer
it will return the x-axis desired.

it works perfectly but i would like to know if there is a better more effiecent way to do it because what if i had many more measures

Re: Dynamic X-axis on Column Chart based on selection

tamerj1 — Mon, 01 May 2023 09:27:57 GMT

eliasayyy
Actually this is what I had in mind 😄

I was just afraid that adding the new relationships will create ambiguity as I have no idea how your data model look like.

Re: Dynamic X-axis on Column Chart based on selection

eliasayyy — Mon, 01 May 2023 09:37:46 GMT

oh well in that case thank you very much for the help