How to create a bar plot with overlapping x-axis (overlapping time intervals)
I want to create a PowerBI visual that looks like (the artificially in Excel created) example below:
I have two x-axis: 1 category "success" and "no success" and 1 with different time intervals (last month, last three month, last 6 month, ...) where the data is cumulated.
Since the time intervals are overlapping (the last month is also included in the intervals before (except the first one), the last 3 month are also included in the last 6 and 12 month, and so on...), I do not know how to create such a visualization in Power BI.
The bars give the value whereas the line should be a trend over the results of the different time intervals.
The raw data exists in monthly data points and the value is a (PowerBi) measure to calculate the relation (% of "success" have lawyer).