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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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

@Anonymous

 

This is the VISUALIZATIONS section.

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

 

Select the MEASURE from there

chanty.png


Regards
Zubair

Please try my custom visuals

View solution in original post

7 REPLIES 7
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

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


Regards
Zubair

Please try my custom visuals

@Anonymous

 

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


Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

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

@Anonymous

 

This is the VISUALIZATIONS section.

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

 

Select the MEASURE from there

chanty.png


Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

sorry my bad 😞     its found now  thanks alot 🙂

tarunsingla
Solution Sage
Solution Sage

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!

 

Anonymous
Not applicable

Hi,

 

i have tried its disabled in  modeling tab 😞

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.