Power BI Deskstop

Question

Hi Community,&nbsp;&nbsp;&nbsp;I Want To Change The Format Of Dynamic Measure Selector for 2 Different Measures.&nbsp;for Ex. measure 1= currency&nbsp;&nbsp; &nbsp; &nbsp; Ex. measure 2= percentage

pratyashasamal · Answer

Hi&nbsp;Anonymous&nbsp;,You can first select the measure then go Measure tools and change the format for the measure.Thanks ,Pratyasha SamalHas this post solved your problem? Please&nbsp;Accept as Solution&nbsp;so that others can find it quickly and to let the community know your problem has been solved.If you found this post helpful, please give&nbsp;Kudos&nbsp;C

anonymous · Answer

Actully This 2 measures in a single column&nbsp;

pratyashasamal · Answer

hi&nbsp;Anonymous&nbsp;,These are 2 separate measures right ?If it is using the same column in its calculation ,then also it would not cause any issue .Thanks ,Pratyasha SamalHas this post solved your problem? Please&nbsp;Accept as Solution&nbsp;so that others can find it quickly and to let the community know your problem has been solved.If you found this post helpful, please give&nbsp;Kudos&nbsp;C

anonymous · Answer

Slicer Selection = IF (&nbsp; &nbsp; ISCROSSFILTERED ( Selections[Slicer Selection]),&nbsp; &nbsp; SWITCH (&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( Selections[Slicer Selection]),&nbsp; &nbsp; &nbsp; &nbsp; "Sales/Hour Worked", 'CBS'[Sales],______For this i want to show currency&nbsp; &nbsp; &nbsp; &nbsp; "Tax", 'CBS'[10% tax],______For this i want to show percentage&nbsp; &nbsp; &nbsp; &nbsp; "HWorked", 'CBS'[total work hours],&nbsp; &nbsp; &nbsp; &nbsp; "LExpenses",'CBS'[lbr exp]______For this i want to show percentage&nbsp; &nbsp; ),&nbsp; &nbsp; " "&nbsp;)

pratyashasamal · Answer

Hi&nbsp;Anonymous&nbsp;,You can also use this method :-If you use DAX to create a measure for the field you are using you can wrap that in the format function, e.g.Measure = FORMAT( SUM( Table[Sales]),&nbsp;$#,##0;($#,##0) )&nbsp;The format function can take user defined formats as shown above (above is brackets for negative, comma separated dollar format.For a bigger list of user defined function see here:&nbsp;https://msdn.microsoft.com/en-us/library/ee634206.aspxYou can also refer to this link :-https://radacad.com/custom-format-fields-and-measures-in-power-bi&nbsp;Thanks ,Pratyasha SamalHas this post solved your problem? Please&nbsp;Accept as Solution&nbsp;so that others can find it quickly and to let the community know your problem has been solved.If you found this post helpful, please give&nbsp;Kudos&nbsp;C

Forum Discussion

Power BI Deskstop

5 Replies

Related content

Power Apps for Power Bi

Power BI License

Image display in Power bi report

power bi

Power Bi refresh