How to create a bar graph with category and TW, LW on the x - axis

[jay007]

Hi everyone,

I am new to PowerBI and the business has a requirement to recreate a bar graph visual in the tool. I've been searching around and am not too sure how the following can be recreated in power bi.

Sample Graph shows stock levels of a group of products over a 3 week period

• category (big spaces between the 3 coloured bars) represent products
• coloured bars represent this week, last week, and 2 weeks ago for each category

Cheers,

Jay

[jay007 · Accepted solution]

Solved it myself.

Drag the date column to Legend and apply a filter on the required date period