Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |