Forum Discussion
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 not thinking about ?
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
4 Replies
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
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.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
