Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to create a bar plot with overlapping x-axis (overlapping time intervals)

Hi,

 

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).

 

Thank you in advance.

 

Best regards

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      thanks for the reply. The data looks something like the following table (I don't know how to add a table here - without filling every cell by hand):

       

      The percentage of lawyers is calculated by amount_lawyer / amount_all. "success" the binary category and year and month the time reference (which needs to be grouped in overlapping categories).