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.
Team , i have KPI which some number need to be percentage and some need to remain the same.
What my visual looks like is :
For Ex : DOI , 13.26 , this number remain on Visualization the same
But Logistics Cost Per Unit Case : 0.16 , this number need to be percentage % on visualization.
I have no idea how to build this while these numbers are different label and Can't make it well on visualization and even on the Table visualization itselves.
My purpose is to get all of those number in the same vusualization If it's DOI , need to be 13 , or if it's logistic cost per case it's 16%.
please let me know what is the possible way to acheive it.
Solved! Go to Solution.
Hi @Chanleakna123,
If you also would like to return when the Column1 value is "Total SC Costs Per Case", you can modify the condition below:
Column = IF('Table1'[Column1]="Logistics Cost Per Unit Case" || 'Table1'[Column1]="Total SC Costs Per Case",FORMAT('Table1'[Column2],"Percent"),FORMAT('Table1'[Column2],"General Number"))
Best Regards,
Qiuyun Yu
Hi @Chanleakna123,
One measure/column can't return different data type values. In your scenario, you need to use Format() function to change percentage and normal numbers as TEXT type values.
You can create a calculated column like below:
Column = IF('Table1'[Column1]="Logistics Cost Per Unit Case",FORMAT('Table1'[Column2],"Percent"),FORMAT('Table1'[Column2],"General Number"))
Best Regards,
Qiuyun Yu
@v-qiuyu-msft , if i have 2 text turn to Percentage ,
what calculation should i add in the calculated column ?
IF('Table1'[Column1]="Logistics Cost Per Unit Case",FORMAT('Table1'[Column2],"Percent"),FORMAT('Table1'[Column2],"General Number"))
Hi @Chanleakna123,
If you also would like to return when the Column1 value is "Total SC Costs Per Case", you can modify the condition below:
Column = IF('Table1'[Column1]="Logistics Cost Per Unit Case" || 'Table1'[Column1]="Total SC Costs Per Case",FORMAT('Table1'[Column2],"Percent"),FORMAT('Table1'[Column2],"General Number"))
Best Regards,
Qiuyun Yu
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |