Forum Discussion

AldoJavier26's avatar
AldoJavier26
Frequent Visitor
4 years ago
Solved

Space out columns values with same date axis

Dont seem to find a clear answer on this anywhere..is there a way to space out the columns on my chart with the same (year) axis? Is there a different approach to my +20%,+40%,+60% measures that Im n...
Need Help
Show and Tell
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Using the default clustered bar chart, there is a clumsy way which involves creating measure which return blank and place them between the other measures (though I haven´t found a way to change the colour for the legend)

     Or you can create a new table with the % Values:

     

    and use the % Value field as the x-axis, the Fiscal Year for the "column series"  and create this measure for the values:

    Values =
SWITCH (
    SELECTEDVALUE ( '% Table'[% Value] ),
    "+20%", [FY FC based on PY YTG (20%)],
    "+40%", [FY FC based on PY YTG (40%)],
    "+60%", [FY FC based on PY YTG (60%)]
)

    You can then use the formatting options for the x-axis to get:

     

    I've attached you PBIX file 

     

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Using the default clustered bar chart, there is a clumsy way which involves creating measure which return blank and place them between the other measures (though I haven´t found a way to change the colour for the legend)

 Or you can create a new table with the % Values:

 

and use the % Value field as the x-axis, the Fiscal Year for the "column series"  and create this measure for the values:

Values =
SWITCH (
    SELECTEDVALUE ( '% Table'[% Value] ),
    "+20%", [FY FC based on PY YTG (20%)],
    "+40%", [FY FC based on PY YTG (40%)],
    "+60%", [FY FC based on PY YTG (60%)]
)

You can then use the formatting options for the x-axis to get:

 

I've attached you PBIX file