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
Gstewey
Regular Visitor

Define percentage

Hello,

 

I have a table that gives me my Labor Cost, Overhead Cost, and Material cost.    

 

My labor cost is a column in Job Detail table

My Overhead cost is a column in Job Detail table

My Material cost is a Measure in the Job Detail Table.

 

I need to present the Percentage of each that can only total 100%    For instance a bar graph that shows Labor cost may by 25%, Overhead may be 56% and Material at 19%.  (those are example percentages)     

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @Gstewey 

 

You can use the 100% Stacked column/bar chart visual. They show the percentages only. 

vjingzhang_0-1682564988425.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @Gstewey 

 

You can use the 100% Stacked column/bar chart visual. They show the percentages only. 

vjingzhang_0-1682564988425.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Thank you  v-jingzhang!   That worked perfectly!

Gstewey
Regular Visitor

I Should add...all of these are currently giving me $ amounts.   I just need to show what percentage of each is too a particular job.    I have them displaying the cost already...between the three they total 100% of a job.   Now I just need to show, them as a percentage instead of a $ amount.

 

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.