Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have table in Power BI having two columns. I need want show 0.31 as 31% which is 0.31 multiply by hundred and add % at last for only for values stock tank B2 (EUC) and Stock tank C(Res/ARS) like 31% and 12% remaining all other values does not change. How to do this using Dax in Power BI.
Output:
Tag_Description | Value |
Stock tank B2 (Euc) | 31% |
Stock tank C (Res/ARS) | 12% |
Stock tank D (Res/ARS) | 0.00 |
Wickit 1285 (#/ton) | 6.99 |
CMC Calexis (#/ton) | 2.99 |
Solved! Go to Solution.
Sorry change the last part of the measure ,"#")) to ,"0.00")) for decimal
Thanks for your help, I am new to Power BI in learning phase. I have tried the measure but it showing the out as 0.31% and 0.12% not as 31% and 12%.
Also if you don't want the .00 after the percentage you can change "percent" to "0%" full measure below:
Hi This is measure is working good showing values 31% and 12%. but all the values are showing empty.
In my table ther are only five stock tank B2 but all the others it is showing as Stocktank B2 and empty. same for values taking for all the columns after applying the measure
example:
there five rows in table one row is stock tank B2 . it chnage the value for 31% for paticular rows. it shwoing five rows with stcok tank B2 and one 31% others empty
Without seeing more of what is in the file it's going to be difficult to tell why that's happening. Have you got a copy of the PBI file i can take a look at?
This measure is working fine now. Thanks a Lot. How to do as New column without the measure. Is it Possible.
I believe due to the different formats you want within a single column it will need to be a measure.
Power BI Desktop is a business analytics service provided by Microsoft that allows users to create reports and visualizations using their data. I use this WordPress blog editor on my website 먹튀사이트 Power BI Desktop includes a wide range of features, one of which is the ability to create tables.
Sorry change the last part of the measure ,"#")) to ,"0.00")) for decimal
Hi @Rajeshcric424 ,
Check the following solution, where you use IF, SELECTEDVALUE and FORMAT together:
https://community.powerbi.com/t5/Power-Query/How-to-change-row-data-from-decimal-to-percentage/m-p/3...