cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chanty4u Member
Member

RE: show measure values in %

Hi all,

 

i have used few measures in matrix table

 

but that measures  i need to show as % values .. 

i used below measure for example   but result values coming as  0.01 

 

TCV(HW)Margin% = sum(vw_daas_Total_Contract_Value_Orders[Total_Contract_Value_Hardware_Margine])/sum(vw_daas_Total_Contract_Value_Orders[Hardware_Total_Contract_Value])
 
per.PNG
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: RE: show measure values in %

@Chanty4u

 

This is the VISUALIZATIONS section.

There is another section beside it called "FIELDS" section.

 

Select the MEASURE from there

chanty.png

View solution in original post

7 REPLIES 7
Highlighted
tarunsingla Established Member
Established Member

Re: RE: show measure values in %

Select the measure (under Fields), go to Modeling Tab from the menu, select % under the Formatting section.

 

Regards,

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

 

Super User
Super User

Re: RE: show measure values in %

@Chanty4u

 

Just Select the MEASURE from "Fields" section >>Modelling Tab>>Formatting>>Percentage

Chanty4u Member
Member

Re: RE: show measure values in %

Hi,

 

i have tried its disabled in  modeling tab Smiley Sad

Super User
Super User

Re: RE: show measure values in %

@Chanty4u

 

Did you select the MEASURE first from the "FIELDS" section?

Chanty4u Member
Member

Re: RE: show measure values in %

Hi,

 

yeah i have selected but.. its not selecting 

 

i have 3 % columns.. but im unable to select .. when i double click  its asking to rename only.p_cl.PNG

Super User
Super User

Re: RE: show measure values in %

@Chanty4u

 

This is the VISUALIZATIONS section.

There is another section beside it called "FIELDS" section.

 

Select the MEASURE from there

chanty.png

View solution in original post

Chanty4u Member
Member

Re: RE: show measure values in %

sorry my bad Smiley Sad     its found now  thanks alot Smiley Happy

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 100 members 1,663 guests
Please welcome our newest community members: