Forum Discussion
Helper ISubtable in Matrix Visual - from SSRS to Power BI
Hello,
I try to convert few reports from SSRS to Power BI. Some of them are really tricky especially when i comes to default values or expressions. but that is a different kettle of fish...
In this case I try to migrate a report with subtable to Power BI.
Data:
| Item | color | qty |
| A | red | 5 |
| blue | 6 | |
| B | red | 3 |
| black | 5 | |
| C | yellow | 8 |
| purple | 2 |
Estimated report
| Item | qty all | Subtable | ||||||
| A | 11 |
| ||||||
| B | 8 |
| ||||||
| C | 10 |
|
all i get is this
| item | red | blue | black | yellow | purple | Qty all |
| A | 5 | 6 | 11 | |||
| B | 3 | 5 | 8 | |||
| C | 8 | 2 | 10 |
we have even more colors and items. so it is getting very messy.
can you help me to get this done with nested tables. Or is there an other way like this?
best wishes
Benedikt
2 Replies
- amitchandak
Super User
Benedikt_Sch , I doubt you can get the second output with the standard matrix or table visual
You can check custom visual :https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
You can consider this excel feature in the power bi app
Excel in Power bi App
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg
Benedikt_SchHi amitchandak ,
thanks for the quick reply.
I've already searched the forum and also looked for other visuals. Unfortunately without success.
Maybe there is someone here with a clever idea or a workaround to solve the Problem differently.
I faced a similar problem mentioned in the second video few month ago, but sloved it in Power BI using Values to rows. This way my users where happy with the solution. But for this actual problem I have no idea left to solve it..
Benedikt
