Forum Discussion

Olifer's avatar
Olifer
Frequent Visitor
5 years ago
Solved

Visualization: Two Bar charts attached to one asset

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

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    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.

     

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    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.

     

  • Olifer's avatar
    Olifer
    Frequent Visitor
    5 years ago

    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's avatar
      MFelix
      Icon for Super User rankSuper User
      5 years ago

      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.

  • Olifer's avatar
    Olifer
    Frequent Visitor
    5 years ago

    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