Forum Discussion

newhopepdx's avatar
newhopepdx
Resolver I
11 months ago
Solved

Segmented Bar Chart

Given a table with columns: Date (containing the Sundays {i.e., week ending date} for each week of the year) Plan (a weekly budget amount) Amount (totals for that row's week) and a slicer set to ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    11 months ago

    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's avatar
Ritaf1983
Super User
11 months ago

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

newhopepdx's avatar
newhopepdx
Resolver I
11 months ago

Thanks Ritaf1983,

That will do what we're after.