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 a value that I have used twice in a table, once the normal Sum and the other is the same but shown as Percent of Grand Total. In the picture, they are respectively #Kund and %Kund. I'd like to get rid of the two percentage decimals without creating a new column or measure for it. But I cannot seem to find the option.
Solved! Go to Solution.
@Anonymous
You need to create a measure for the #Kund format with zero decimal percentages.
The built-in % of Total doesn't allow you to change the percentage decimals.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
You can go to Specific column setting and change the decimal parameter
Thank you! So, was just checking if there was an alternative to it.
@Anonymous , Create a measure like
divide([#kund], calculate([#kund], allselected(Table)))
@Anonymous
You need to create a measure for the #Kund format with zero decimal percentages.
The built-in % of Total doesn't allow you to change the percentage decimals.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group