Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |