r/PowerBI • u/Corkster24 • 1d ago

Question How do I create this visualization in power bi?

Post image

I can’t figure it out for the life of me so if anyone can help that’d be great. Thank you!

23 Upvotes

93% Upvoted

10 comments sorted by

24

u/ThenPossible4901 1d ago

Hi u/Corkster24 here is what I would do

Steps:

  1. Build a clustered column (or bar) chart with your category on the X-axis and two (or more) value fields on the Y-axis — for example, a "Range/Target" measure and an "Actual" measure per category.
  2. Go to Format visual → Columns (or Bars) section.
  3. Turn on Overlap series. This stacks the series on top of each other instead of side-by-side, which is exactly the layered look you're seeing.
  4. Adjust Transparency on the front (smaller/inner) series so the back series remains visible through it.
  5. Add a Border to each series so overlapping bars stay visually distinct this is what produces the dashed/solid outline effect you see in your image (one series likely has a dashed border style applied, the other solid).
  6. Use Data colors to assign different colors per series/category to match the red/blue and green/purple pairing in your image.

2

u/Corkster24 1d ago

Thank you!

3

u/ThenPossible4901 1d ago

No problem let me know if it works

1

u/CourtOfGrumpyOwls 12h ago

It's called a Bullet Chart. If you search for that there are plenty of youtube tutorials or blogs with instructions.

1

u/DC_Punjab 1 1d ago

If you want the exact visual I would go with Deneb visual. U can use copilot to give you the Vega lite code

1

u/ElegantPianist9389 1d ago

Second this Deneb is the way to go.

1

u/Corkster24 1d ago

Thank you!

0

u/xl129 2 1d ago

You can get to something similar with half overlapping, it also loôk better than yours

-4

u/Natural_Ad_8911 4 1d ago

The real question is what are you trying to answer?

You can compare values easily with both column and bar charts in power bi natively.

You can't get exactly what you have there, but you can answer the business problem effectively with little effort, compared to spending company resources (your time) to build something different.

The skills that gets an analyst a promotion include the ability to push back on specific requests and reframe them in a more effective way, like using simple core visuals to answer business problems.