TRICKY - Show both £ and % in same column

[Anonymous]

Hi Experts

How would you amend the current DAX Measure to add percenatge value based on External Sale into the Measure - So the  Column show both the data and percentage values as shown in the excel file attached.

Excel File.

https://www.dropbox.com/scl/fi/pku9r6ojigak7uv1otbiu/Values.xlsx?dl=0&rlkey=2gmprbli0xsw98dbijjbw3ro... 

Sample PBIX

https://www.dropbox.com/s/t1lbguwygrc5nzn/PLP_Test_2%20%281%29%20%281%29.pbix?dl=0 

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

In Power BI, one column will have only one column type.

If you want to show (%) percentage type and (£)fixed decimal number type in the same column, you can build a calculated column or measure in text type.

For more details about mixed data type column: columns with mixed data types

Your Excel and Sample PBIX have beem deleted Currently.

If this reply still couldn't help you solve your problem, please share the sample with me agian by your Onedrive for Business.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , refer if these two can help

https://community.powerbi.com/t5/Desktop/Different-row-data-Type-in-Matrix/td-p/590902

https://radacad.com/dynamically-change-the-format-of-values-in-power-bi

[Anonymous]

Hi Amit 

This article outline how to format the data points i need to calculate the % values and add them into the current DAX Measure - which i cannot do??