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 All,
we have some percentage value basis on single direct column on the card visualization which we need to modify with only two digits percentage and I have adjusted /reduced percentage digit also in power bi desktop.
example: we have value like this -144424% and we need to modify it to 14 % . Kindly help how to display two value digit percentage on the card visualization .
Thanks,
Raghu
Hi @Anonymous ,
You want always display the first and second number of this vaule?
Maybe you can try this:
var _len = len(SUM(final[region_involvement_score]))
return
SUM(final[region_involvement_score])/POWER(10,_len)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Chenwu,
i have tried but still no luck. i want to show pecentage on single column using card visuvalization .
PFbelow screenshot.
Thanks,
Raghu
Hi @Anonymous ,
Use FORMAT( [values], "00%" )
Or modify the result as the screenshot.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Chenwuz,
i am new to power bi . can you please provide screenshot for to get two numbers percentage?
i have tried below changes still not getting
i need to show like this
Thanks,
Raghu
Thanks for sharing PBIX file. here i need to display percntage value based on sigle column i dont have any other columns which shared above post.
Kinldy help..
Thanks,
Raghu
Hi Amit, i have donr like this -
Still getting same value . could you please send formula ?
@Anonymous , I think first divide the actual value by 100 and then mark it as a percent column.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Amit, i have done like this -
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 |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |