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
Demote to header as row
Transpose
After Transpose
Promote first row as header
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.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
369 | |
99 | |
67 | |
57 | |
48 |
User | Count |
---|---|
329 | |
116 | |
88 | |
73 | |
61 |