cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Post Prodigy
Post Prodigy

TRICKY - Show both £ and % in same column

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 

 

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @Route217 

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. 

 

View solution in original post

3 REPLIES 3
RicoZhou
Community Support
Community Support

Hi @Route217 

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. 

 

View solution in original post

amitchandak
Super User IV
Super User IV

@Route217 , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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??

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors