Forum Discussion

brose's avatar
brose
Regular Visitor
6 years ago

Graph with Month and Week on the X axis

 

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! 

Need Help

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      brose
      Regular Visitor
      6 years ago

      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