cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Showing Values as % of Axis

Hello,

 

I'm new to Power BI and i'm trying to migrate some excel reporting into this space moving forward.  I have a chart that I regularly publish in Excel that has the following elements:

 

 - Item Volume

 - Item % In-Stock (defined in the table as a 1/0 count)

 - Item % Stock-Out (defined in the table as a 1/0 count)

 

In excel I "show values as % of Row total" and this makes the graphing easy for me.  Is there a way do to the same thing in a Power BI visual?  I have used ToolTips and Changed the values, but am only able to show as a % of the grand total.  I need to show as a grand-total of the X-Axis values (plant number).

 

Please help!

1 REPLY 1
Highlighted
Helper I
Helper I

PBI-Snag.png

 

Hi Kvonck,

 

I use the 1/0 approach for a lot of things as well.  Select the column in the fields menu (Far right), then select "Modeling" from the menu at the top.  Change the format to percentage.  I assume you are already averaging the 1/0 count, but if not I can show you a screen shot for that as well.

 

Hope this is what you are looking for.

 

Best,

Jim

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors