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 PowerBI community,
I'm relatively new to PowerBI and have been working through some exercises to get familiar with the tool. I started with Bank example In that process , while selecting balance into value field its showing first , last , count(Distinct) And count instead of total balance .
Any insights or guidance on resolving these problems would be greatly appreciated.
Thanks in advance for your assistance.
Solved! Go to Solution.
Hi @Gurjeet
This happens because the data type of the balance is not a number.It seems that you should fix it from PQ
In the first step replace a $ sign with nothing
And then change the data type to the number:
press "close and apply"
If you want to format the number as a currency, format the column from the model view
Then you will have an option to summarize
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Gurjeet
This happens because the data type of the balance is not a number.It seems that you should fix it from PQ
In the first step replace a $ sign with nothing
And then change the data type to the number:
press "close and apply"
If you want to format the number as a currency, format the column from the model view
Then you will have an option to summarize
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 |
---|---|
107 | |
92 | |
74 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
104 | |
80 | |
66 |