Building bullet charts in Power BI reports
ฝัง
- เผยแพร่เมื่อ 2 ก.พ. 2025
- How to read and use bullet charts when comparing actuals to a target in Power BI, and the different options you have to make these charts in Power BI reports.
Article and download: sql.bi/854409?...
How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...
Brilliant as always. Kurt's tutorials are from another galaxy. Thanks for sharing.
Thanks Kurt. Your content is always excellent. I hope more content creators adopt this approach. I think if it as lean. No unnecessary weight. Direct and focussed but still complete and comprehensive. I want to let you know at least one person appreciates this structure. LinkedIn and TH-cam are too full of content creators with mixed agendas. They are chasing the algorithm and not interested in genuine information sharing and mentoring. Marco and Alberto, Zoe and The Cube guys feel the same to me. Great work again.
Hey that really means a lot. I'm really happy you shared this and that my vibe is coming through. I indeed don't care about the algorithm at all and my focus is just on trying to be clear, helpful, and not boring. :) Cheers!
I totally agree, but soneone should tell the guy that smilling from time to time is allowed.
That's an amazing tutorial from Kurt! A solid information for building a visualization.Thank you!
Sir, you are truly living up to SQLBI standards or may be even surpassing them
I so dearly wait for your video, Kurt
Love these type of videos from Kurt!
Thanks Kurt for another great video! I especially appreciated the whiteboard section (6:30 to 21:30). You gradually build up the bar charts in complexity, focusing on the meaning communicated to the report user while subtly signaling chart mechanics to the report creator audience. On the whiteboard, my brain naturally filled in the mechanics, which helped me better understand the content: "Oh! I can imagine replicating that", or "I *think* I know where that setting is ", or "I didn't realize that was possible!". Balancing two simultaneous messages is tricky, but you nailed it here. Great job!
***Question***: What whiteboard tool are you using here? I'd like to look into it for the internal training videos I create at work.
edit: I saw on your 2024 review blog post you mention excalidraw.
excellent resource! learned alot here. thanks.
Great video Kurt!! I'm going with McGivering approach or even a custom visual from the store.
As always, very insightful! Thank you :)
Fantastic video thank you
Hey Kurt, great video as always. Thank you so much for sharing this. The Bullet Graph with coloured bars instead of the coloured difference to the target could be visually misleading. Home Appliances looks less dramatic than Computers but the opposite is the case. I have learned that in the IBCS seminar to earn the IBCS certified consultant and I felt a bit ashamed as a Tableau enthusiast as Tableau lists this version of a bullet graph as a visual best practice. 😳It makes the paid version worth the price where you can visualise the difference or to use Denep with the action dots. But again, your videos are fantastic and the techniques you demo are super helpful.
Thank you, great content! Is that chart included in power bi? or is it formatted in a different way? It looks great
Thanks. For quite good information, but it's good that PBI should give such functionality in default charts, isn't it?
This is a very useful visual, hope PBI will provide such functionality in upcoming updates.
I agree!
Adding Bullet charts in tables using SVG for me does not work for negative values.
Indeed in this case you might want to consider a different approach like a connected dot plot / dumbbell! See the last video "creating custom visuals in Power BI with DAX" for more info.
DAX Jesus gone Deneb.
You have just demonstrate that Power BI is extremely limited in visualization types. Excel still has more visualization types than PowerBI 🤦🏻♂️ (custom visual don’t count because 97% of them don’t work properly, or you have to pay a monthly fee to use them, and the formatting options are too poor. They are simply not an option).
You should help us (the average users) to push the Power BI team to stop releasing irrelevant features in the monthly update and instead go back to the time where new visual were added like key influencers.
Your example was with a simple bullet chart, but it replicates with so many other needed visual. How is it possible there is not a native box plot?
It’s sad to see how Power BI loose its innovative power.
I agree! And trust me... I am pushing. A lot. I'm not here to defend Power BI; it's just a tool. ;)
A lot of MS efforts are going towards Fabric at the moment.