Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Sample PBIX
https://www.dropbox.com/s/t1lbguwygrc5nzn/PLP_Test_2%20%281%29%20%281%29.pbix?dl=0
Solved! Go to 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.
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.
@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
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??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |