Forum Discussion
Expandable Table Visual
I would like to display a hierarchy of records in a table format that can display properties for the parent record (that are not aggregates of the child record values) and allow you to expand and col...
Thanks for the solution des_san.
Any thoughts on how you'd not show the parent record when drilling down?
e.g. for example using Sample 2 as an example being able to see something like this:
| Parent | Measure1 | Measure2 |
| Parent 1 | Green | Collected information. |
| Child 1.1 | Yellow | Confirm list |
| Child 1.2 | Yellow | Blah |
| Parent 2 | Green | Parse information. |
| Child 2.1 | Yellow | list data. |
| Child 2.2 | Green | Blah blah |
des_san
Advocate I
Advocate IYou could try a SWITCH() calculation and define your own heirarchy fields. Here are good examples:
Parent-child hierarchies – DAX Patterns