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 

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, AldoJavier26 ;

You could use custom visual-Definitive Logic PBI Clustered Column Chart with Custom Labels; 

The final output is shown below:

In addition ,you also could create two blank measure.

blank1 = 
blank2 =

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AldoJavier26's avatar
AldoJavier26
Frequent Visitor
4 years ago

Thank you for these options. Personally I dont love the blank measure option and for my purposes, the alternate visual does not allow you to update the display unit