Graph with Month and Week on the X axis

[brose]

Hello Everyone!  I would like to create a graph like the one seen below where I'm able to show the months utilization in the bar graph and the weekly utilization in the line part of the graph.  Is this something I would be able to do in PowerBI? Any help would be much appreicated! 

[v-alq-msft]

Hi, @brose 

Based on your description, i created data to reproduce your scenario.

You may create a measure as follows to filter which day of a week should be used in visual to show results.

   Measure = WEEKDAY(SELECTEDVALUE('Table'[Date]))

Finally, you may achieve your requirement with the ‘Line and Stacked Column Chart’, put the measure to ‘Filters on the visual’, configure as follows.

If I misunderstand the your thoughts, please show me your expected output and sample data. I am glad to solve the problem for you.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[brose]

Allan - Thank you very much for responding.  In the example you sent, it looks like both the line and bar are using "weekly" values.  What I would like is for the bar to show the utilization for the entire month, while the line shows the utilization for each of the weeks within that month.  So there would be one bar for each month, and then a point in the line for each week.  Does that make sense? @v-alq-msft