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

Shahid12523's avatar
Shahid12523
Community Champion
11 months ago

- Use a date slicer to filter week-ending Sundays.
- Create three measures:
- CY Amount: Sum of Amount for selected weeks this year.
- Plan Total: Sum of Plan for selected weeks.
- PY Amount: Sum of Amount for same weeks last year.


- Visual Options:
- Stacked bar chart with all three measures side-by-side per week.
- Or three separate bar charts—one for CY, one for Plan, one for PY.