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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Show 2 measures value on stacked column chart

Hi: 

 

Am learning (and loving!) PowerBI - 

currently working on a project status report where I need to report on project cost and completion %

The Stacked Column Chart visualization looks good but am not able to show only one measure. 

An output like this will be ideal ! - any way it can be achieved with this (or any other) visualization ? 

 

2019-08-08_17-06-29.jpg

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

Hi @Anonymous ,

 

Believe that the best way to achieve this visual is to use the Line and Clusted column chart.

 

Try the following steps:

  • Add on the columns the measure with the K amounts
  • Add on the lines the % measure
  • On the options
    • Y-Axis - Turn off secondary axis
    • Shapes
      • Turn of marker and reduce line size to 0
    • Data labels
      • Customize series and setup each one for the desire size and location

Final result should be something like this:

line_column_chart.png

Regards,

MFelix

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Forgot to mention that you need to format on the chart each of the data values one to automatic or thousands and the percentage measure to none.

Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

Hi @Anonymous ,

 

Believe that the best way to achieve this visual is to use the Line and Clusted column chart.

 

Try the following steps:

  • Add on the columns the measure with the K amounts
  • Add on the lines the % measure
  • On the options
    • Y-Axis - Turn off secondary axis
    • Shapes
      • Turn of marker and reduce line size to 0
    • Data labels
      • Customize series and setup each one for the desire size and location

Final result should be something like this:

line_column_chart.png

Regards,

MFelix

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@MFelix - Thank You for the response - you've shown me some light 🙂 - running into a snag here 

Y:axis - when I turn off the secondary axis the % number is getting changed 

with_SecondaryAxisOff.jpg

 

Keeping the secondary axis on is not letting me put the % numbers inside the bars 😞 

 

with_SecondaryAxisOn.jpg

Forgot to mention that you need to format on the chart each of the data values one to automatic or thousands and the percentage measure to none.

Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@MFelix - you are a PowerBI rock star ! 🙂 - Thank You - 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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