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 am new to power bi, I am trying to achieve a view which gives me % of disk space used by an application. What I want is below graph to represent 100% and ligh blue to show how much of 100% of disk is used. exampe first one is 65%
this is a sample of what my data look like
category | disk | space used | total space | space free |
a | 1 | 40 | 120 | 80 |
a | 2 | 30 | 50 | 20 |
b | 1 | 50 | 100 | 50 |
I want my view to be across category as you can see one category can have multiple lines so when I do sum(space used)/sum(total space) what is does is calculate percentage per row and sum it up whereas the case should be summing up the measures first and then calculating the percentage
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
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 |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |