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.
Dear community,
Below is what is visual in my power Bi dashboard
Parent Cost Type | Plan Total | MLO | Actual USD Constant |
PTW | 73506.22259 | 73506 | 17098 |
People Cost | 68571.10653 | 68571 | 30362 |
SLSL | 30184.64045 | 30185 | 11717 |
Other | 0 | 0 | 79 |
Sold Time | -5261.96957 | -5262 | -2986 |
i would like to achieve below
Parent Cost Type | PTW | People Cost | SLSL | Other | Sold Time |
Plan Total | 73506.22259 | 68571.107 | 30184.64 | 0 | -5261.97 |
MLO | 73506 | 68571 | 30185 | 0 | -5262 |
Actual USD Constant | 17098 | 30362 | 11717 | 79 | -2986 |
let me know how can i achieve this?
That greatly depends on what your original source data looks like, how is that structured? Is it like the first table?
Try to follow the below steps
unfortunately, this dataset is very small, as i have only provided the visuals table.
i am not in favour of doing this in power query, as this could effect my dashboard.
is there any mesure we can create?
Can please share your PBIX file with sample data.
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 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |