Forum Discussion
Segmented Bar Chart
Hi newhopepdx
In Power BI there are fewer customization options compared to Excel or PowerPoint. To get a layout like yours, you need to start with a proper table structure.
The right approach is:
Build a table with Year / Week / Value / Sort (as in your screenshot).
Place Year on the Y-axis.
Use the Sort column so that the Plan row appears in the middle between the years.
Put Week in the legend, so each week is represented as a separate stacked segment.
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983,
I appreciate your input. And I plan to use the actual vs budget type chart on detail pages. The chart I'm trying to replicate in PBI is currently being created by updating the data by hand each week in Powerpoint using a custom Combo bar chart. Here are the details. (In the Legend Entries (series) column, "Plan" sets on the row below the 5 weeks).
I'm hoping we can replicate this in PBI where we can, via a slicer and measures, fill in the data ranges needed.
Hi newhopepdx
In Power BI there are fewer customization options compared to Excel or PowerPoint. To get a layout like yours, you need to start with a proper table structure.
The right approach is:
Build a table with Year / Week / Value / Sort (as in your screenshot).
Place Year on the Y-axis.
Use the Sort column so that the Plan row appears in the middle between the years.
Put Week in the legend, so each week is represented as a separate stacked segment.
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks Ritaf1983,
That will do what we're after.