Dynamic formatting based on Selected Value

[mohammadyousaf]

Hi, 

I have a case where I want to display Unit of Measurement Dynamically. 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 

2,345 | Nos. 

Activity_ID is taken from Table_Activity_Master column Activity_ID
Unit is taken from Table_Activity_Master column Unit_Name

Any help is muchappreciated. 

[Ritaf1983 · Accepted solution]

Hi @mohammadyousaf 
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-colu...

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

[mohammadyousaf · Accepted solution]

Hi, I managed to solve the issue by little research.. Here is the dax I used

VAR BaseFormatString = "#0,0"

VAR Measurement_Unit = SELECTEDVALUE (tbl_Activity_Master[Unit_Name], "***")

VAR FormatString = BaseFormatString & " | " & Measurement_Unit

RETURN

    FormatString

Thanks to SQLBI, https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/

[Ritaf1983 · Accepted solution]

Hi @mohammadyousaf 
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-colu...

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