Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Stacked Column Chart with Extra Functions

Hi,

 

I am looking for a chart like this where green color represents the total order which is 100  for that 1st bar and violet color represents the completed orders which is 50 and also i am looking for the completed % to be appeared in the data label which is 50%.

 

Visual.JPG

1 ACCEPTED SOLUTION
lkalawski
Memorable Member
Memorable Member

Hi @Anonymous

You can use stacked column chart with line and you need to adjust the appearance of the chart accordingly. This is the result:

lkalawski_1-1599637404560.png

I am attaching a file with this example: https://gofile.io/d/yKo5HE

If you have any further questions, feel free to write. 



_______________
If I helped, please accept the solution and give kudos! 😀 

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Anonymous - You can do this with some fancy math using stacked column chart. Basically have to take your top value and subtract your bottom value for your top value.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
lkalawski
Memorable Member
Memorable Member

Hi @Anonymous

You can use stacked column chart with line and you need to adjust the appearance of the chart accordingly. This is the result:

lkalawski_1-1599637404560.png

I am attaching a file with this example: https://gofile.io/d/yKo5HE

If you have any further questions, feel free to write. 



_______________
If I helped, please accept the solution and give kudos! 😀 

amitchandak
Super User
Super User

@Anonymous , I think you are looking for an overlapping bar.

 

Bullet visuals can do that. I doubt bar has that option

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380755?tab=Overview

 

In the clustered bar, you can have side by sidebar

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.