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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
216 | |
57 | |
49 | |
46 | |
45 |
User | Count |
---|---|
267 | |
211 | |
113 | |
82 | |
71 |