Forum Discussion
Transform facttable into a customized List with own description names
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.
Hi, Applicable88
I tried to create a visualization as simple as possible.
Please check if the below picture is what you are looking for.
The link to the sample pbix file is down below, and all measures are in the pbix file.
In the sample pbix file, I created a very simple Dim-Status-Table in order to show the description properly.
https://www.dropbox.com/s/pn9klpzme3iu61l/SampleData.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
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.
Jihwan_Kim , thank you very much!
