Enhanced Bar Chart: A Better Alternative to PIE Chart in Power BI

👋 Welcome to ExcelFort! In this tutorial, we're going to simplify your data visualization in Power BI by showing you an elegant alternative to pie charts – the Enhanced Bar Chart. If you're tired of pie charts complicating your data story, this video is a must-watch!

In the interest of full transparency, I'd like to acknowledge the inspiration behind the trick of displaying of the category name above the series bar in this chart which I implemented with a different approach. This idea was primarily inspired by the innovative content from @HowtoPowerBI, who continually inspires creators within our community. Regrettably, I forgot to mention it in the video. I believe in giving credit where it's due, and @HowtoPowerBI deserves recognition for their ideas

----------------------------------------------------------------------------------
⏲ Video Timestamps

00:00 The Limitations of Pie Charts
00:25 Enhanced Bar Charts to replace PIE chart
01:29 Dynamic Format String Application
03:10 Error Bars Application in Power BI
03:46 Apply Dynamic Label Measure
04:24 Finishing Touches
04:58 Conclusion
----------------------------------------------------------------------------------
📜 Video Script Summary
We start by introducing the limitations of pie charts and why they can make data comparison challenging. Then, we delve into the Enhanced Bar Chart, an excellent alternative. Our step-by-step tutorial includes creating a native bar chart, using dynamic format strings, adjusting labels, error bars, and customizing the visualization for a clean and informative look.

By the end of this tutorial, you'll have a sleek and effective bar chart that beautifully represents the percentage of revenue contribution by segments. If you're interested in enhancing your data visualization skills and learning more inventive ways to present your data, make sure to subscribe to our channel for more Power BI tips and tricks.
------------------------------------------------------------------------------------------------

🟢 LET'S CONNECT!
✔ Mobile No: 00966509791858

#powerbi #powerquery #msexcel #excelfort #powerbidesktop​ #powerbitraining​ #DAX

[hellmutmatheus]

this worth gold! thank you for the video and the awesome teaching

[ExcelFort]

In the interest of full transparency, I'd like to acknowledge the inspiration behind the trick of displaying of the category name above the series bar in this chart which I implemented with a different approach. This idea was primarily inspired by the innovative content from @HowtoPowerBI, who continually inspires creators within our community. Regrettably, I forgot to mention it in the video. I believe in giving credit where it's due, and @HowtoPowerBI deserves recognition for their ideas.

[hellmutmatheus]

I tried this approach on July 2024 and the Custom label is disabled. for those with the same issue I was able to solve adding a dynamic title (Data Label > Series: Whole > Title > Custom > Segment label measure ) and disabling the value of the Whole measure label.

[guidoromani]

Thanks you! super clear and super usefull

[PLara-tfeg]

Excelent...really helped. It would be nice to have a .pbix file to practice more scenarios

[tmack]

Love your bite-sized chart tips! Thank You!

[sumeshkumar]

👍 . Is it possible to apply this same formatting in ‘small multiples’ option.?

[WaqasGulll]

Thank you so much for this precious learning video, i have done it. But having 1 issue i dont know how do i resolve. I created this for category. But when i click on year where all categories are not available the chart top area showing blank. Because of Y Axis available where i did Y Axis off.

[catalinatobonfernandez]

Hi, Thank you very nice explanation but I have a question? What happen if I one of the categories did have a value for the period? I try to apply this technique but it still showing the category with the non value, how i can fix this, if I don't want the category there just the ones with values

[williamsrebelo]

Congratulations on the video, follow all the steps in the video, but the graph is not the same, the edges still remain. How do I resolve it?

[RandomlyWisdom]

I'm not able to see 0 added by base zero measure. Can you please help?

[PUPATRIL]

Looks like this one will need updating given Power BI as of February 2024 does not have Error Bars

=/