Forum Discussion

eliasayyy's avatar
eliasayyy
Memorable Member
3 years ago
Solved

Dynamic X-axis on Column Chart based on selection

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...
  • eliasayyy's avatar
    eliasayyy
    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 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