Forum Discussion
Transform facttable into a customized List with own description names
- 5 years ago
Hi, Applicable88
Please check the below picture if it is what you are looking for.
Please correct me if I am wrong.
The top visualization is when you arrange the columns and measures like below
The bottom visualization is when you arrange the columns and measures like below.
Please check the link down below,. I have fix it.
https://www.dropbox.com/s/pn9klpzme3iu61l/SampleData.pbix?dl=0
Thank you very much.
Hello Jihwan_Kim ,
thanks for your big guidance. The outcome is almost what I want. Very interesting that you add another dim table for delivered and process. Very good idea.
But one more thing: is there really no way to put "delivered" and "process" on the left side instead on top? The problem for my client is that total of all orders aren't calculated, only delivered total and processed total separately. The preferred table should look like this:
| orders count | amount total | rev total | |
| Delivered | 44 | 74 | 21.738 |
| Process | 36 | 65 | 19.064 |
| Total | 80 | 139 | 40.802 |
Hope there is a solution to that.
Hi, Applicable88
Please check the below picture if it is what you are looking for.
Please correct me if I am wrong.
The top visualization is when you arrange the columns and measures like below
The bottom visualization is when you arrange the columns and measures like below.
Please check the link down below,. I have fix it.
https://www.dropbox.com/s/pn9klpzme3iu61l/SampleData.pbix?dl=0
Thank you very much.
- Applicable885 years ago
Impactful Individual
Jihwan_Kim , thank you very much!
- Jihwan_Kim5 years ago
Super User
Applicable88 you are welcome.