Visualization: Two Bar charts attached to one asset

[Olifer]

Dear community,

I'd like to ask for your support how the following visualization can be achieved with Power BI. I think the images attached describe best how it should look like: One customer shall receive exactly two bars, located next to each other, one pointing from "Start Date to "End Date", the other from "Start Date" to "Adapted End Date" (which can be earlier or later than the "End Date").

Of course it's fine when Cust1 / Cust2 appear not just once, but behind each of their respective bars.

Any ideas would be highly appreciated!

Thanks a lot and a great weekend to all of you!

Olifer

[Olifer]

Dear Miguel,

highly appreciated - thanks a lot! I will spend some time to try to get it up and running, and I will also check the input data once more. In case I still don't manage, I would be glad to come back to your kind offer.

Best regards

Olifer

[Olifer]

Dear Miguel,

thanks a lot for this innovative and tricky solution! Since my real input data is unfortunately far more complex than the data I provided, I am still struggling in getting it set up correctly. I'll continue to work on it and see how far I come. 

Best regards

Olifer

[MFelix]

Hi @Olifer ,

If you need you can send a private message with additional information about your model and I can try to assist you to get the solution implemented.

[MFelix · Accepted solution]

Hi @Olifer ,

You can search for a custom visualizaition of gant charts however since you have the need to have two dates not sure if you can find anything.

What I did was to create a calendar table and the added the following measures:

EndDAte = IF(MAX('Table'[Start Date]) <= MIN(dimCalendar[Date]) && MAX('Table'[End Date]) >= MAX(dimCalendar[Date]), 1)

Adaptive = IF(MAX('Table'[Start Date]) <= MIN(dimCalendar[Date]) && MAX('Table'[Adapted End Date]) >= MAX(dimCalendar[Date]), 1)

Now created a matrix visualizaiton and place the measures on the values and formatted the conditional formatting.

Result below and in attach PBIX file.