Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 ?
Solved! Go to Solution.
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
Proud to be a Super User!
Paul on Linkedin.
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
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
Proud to be a Super User!
Paul on Linkedin.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
98 | |
96 | |
59 | |
44 | |
40 |