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
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.