Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to recreate the below visual in Power Bi ?

 

Target and Actual are two different column values , Date is the start of week date from individual dates.

  • dm-p's avatar
    dm-p
    6 years ago

    Hi Anonymous,

    If you want to have it as close as possible to your screenshot, the only way I have been able to manage it is with layering two custom visuals that manage line charts as small multiples. The closest fit is using the Line Chart by Akvelon custom visual:

    If you need the y-axis values, this visual will display them on each small multiple. There doesn't seem to be a property to manage this.

    I personally produce a Small Multiple Line Chart visual and the same technique can be used, but I can't quite get it as close - for instance, I can keep a shared axis, but my visual currently doesn't support data labels, e.g.:

    I've attached a sample workbook with my attempts for you to see how you get on with.

    If you want it to be very specific then you can try using Charticulator to reproduce the layout.

    Hopefully this will give you some ideas to explore. Good luck!

    Daniel

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Nothing I can think of in terms of default visuals. You can look in the gallery of extra visuals. Or, you could try SVG or R or Python visuals.

    • dm-p's avatar
      dm-p
      Icon for Super User rankSuper User

      Hi Anonymous,

      If you want to have it as close as possible to your screenshot, the only way I have been able to manage it is with layering two custom visuals that manage line charts as small multiples. The closest fit is using the Line Chart by Akvelon custom visual:

      If you need the y-axis values, this visual will display them on each small multiple. There doesn't seem to be a property to manage this.

      I personally produce a Small Multiple Line Chart visual and the same technique can be used, but I can't quite get it as close - for instance, I can keep a shared axis, but my visual currently doesn't support data labels, e.g.:

      I've attached a sample workbook with my attempts for you to see how you get on with.

      If you want it to be very specific then you can try using Charticulator to reproduce the layout.

      Hopefully this will give you some ideas to explore. Good luck!

      Daniel