Reputation: 13
I have a problem in Power BI Report Builder. As dataset I have a table similar to this:
ID | Parent Group | Child Group | Count |
---|---|---|---|
1 | A | A1 | 1 |
2 | A | 1 | |
3 | A | A2 | 1 |
And i have to generate a Report Builder tablix like this:
ID | A | |
---|---|---|
A1 | A2 | |
-- | -- | -- |
1 | X | |
2 | X | X |
3 | X |
So I have to populate rows with the rules:
I tried with InScope, RowNumber... but i couldn't find a solution. Can you help me?
Upvotes: 0
Views: 84