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.
Hello
I'm trying to display the %GT of a value but the sum of %GTs doesn't total to 100%; different fields will total to 101% or 99%. I saw that if I unfilter my data query in query editor I will get a 100% sum, but I need the filter in the query. Any help getting around this?
Thanks,
ajmonster
Not sure if this contributes to the problem, but I've found that the rounding that takes place when you alter the "Value Decimal Plases" is incorrect; when rounding, say, .15 to the nearest tenth it spits out .1 instead of what should be .2.
Hi @ajmonster,
If it is possible, please share us pbix file with OneDrive or Google Drive. If you can't, please share us some sample data and its desired result which can help us repro your issue.
Without these information, it is hard for us to understand your requirement or even provide any suggestions.
Thanks,
Xi Jin.
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |