Forum Discussion
Graph with Month and Week on the X axis
Community SupportHi, 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.
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