Forum Discussion
hierarchical visualization
Hi to everybody, I write you to ask you a suggestion: I have a chart with the business structure, 2 columns with code structure and code it structures superior, like this UNIT UNIT FATHER 1 ...
Hi Yuliana Gu,
I desidere something like this
| UNIT | SALES | ||
| 1 | 10 | ||
| 3 | 8 | ||
| 6 | 11 | ||
| SUBTOTAL | 19 | ||
| 4 | 26 | ||
| SUBTOTAL | 26 | ||
| SUBTOTAL | 55 | ||
| 2 | 13 | ||
| 5 | 9 | ||
| SUBTOTAL | 9 | ||
| SUBTOTAL | 22 | ||
| TOTAL | 77 |
practically the same result that I would get through an oracle Hierarchical Query
Hi romeo95,
Unfortunately, this is not achievable in Power BI.
If your data source is Oracle DB, and you are able to get this desired output through Oracle query, maybe you could execute the same query when creating data source connection. So that you directly get this structure in data view.
Regards,
Yuliana Gu