Nested table for better readability

[Kreg]

Hi All,

I am facing with the issue to see several additional rows under each applicable parent. For example I have a table:

ID |  Manufacturer  |  Sales    |

1  |  Tesla                | + 10.000  |

2  |  Nissan             |  +8.000    | 

3  |  Renault           |  + 6.000    |

Now, when I click on + I would like to see several additional rows inside like:

ID |  Manufacturer  |  Sales    |

1  |  Tesla                | + 10.000  |

1.1  |  Model 3  |  6.000  |

1.2  |  Model Y  |  2.000  |

1.3  | Model X   |  2.000  |

1.4 | Model S    |             |

Is it possible to create such table with Power BI for better readability? Also, how to color the top 3 Sales field model in green? and that blank fourth Sales field which is blank to highlight in red.

[Kreg]

Thanks @Idrissshatila for quick reply.

Not sure if it works in my case since I see with Matrix Table I am not able to add hyperlinks under ID. Now, with my current table it works in that way. So far I resolved that issue by adding a new table which shows details per each applicable row from the first parent table. Maybe I will go in this way but I push that second table to Drill-through since now with two table on one screen it might be not readability as it should be.

[Idrissshatila]

Hello @Kreg ,

Check if this article would help in your case https://www.daxpatterns.com/parent-child-hierarchies/

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin