Forum Discussion
Dynamic X-axis on Column Chart based on selection
- 3 years ago
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 thisGA 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
Hi eliasayyy
Probably can be done but you need to share a sample file.
- eliasayyy3 years agoMemorable Member
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 thisGA 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