Dynamic formatting based on Selected Value

Question

Hi,&nbsp;I have a case where I want to display Unit of Measurement Dynamically.&nbsp;For example, If Selectedvalue[ACTIVITY_ID] type , than it should show the values formatted as #0,0 along with unit of measurement. Expected output will be&nbsp;2,345 | Nos.&nbsp;Activity_ID is taken from Table_Activity_Master column Activity_IDUnit is taken from Table_Activity_Master column Unit_NameAny help is muchappreciated.&nbsp;

ritaf1983 · Accepted Answer

Hi&nbsp;mohammadyousaf&nbsp;Please check the option of dynamic string formatting.You can refer to my answer in the linked discussion, which includes Pbix with a small example
https://community.fabric.microsoft.com/t5/Desktop/Change-the-currency-symbol-format-for-a-value-column-based-on/m-p/3564491
If it doesn't help
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...Please show the expected outcome based on the sample data you provided.https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
&nbsp;

Forum Discussion

Dynamic formatting based on Selected Value

2 Replies

Related content

Dynamic Formatting Error

Dynamic formatting

Dynamic number format

Dynamic images based on selections

Dynamic String Format