Table report with row expansions (+ like excel)

Power BI
1

Hi, I want to make a table style report with row expansions.

I have made a report before in the style Sam teaches for creating a P&L template and using the switch function to determine what falls on each total line etc. This makes a really nice summary report.

However the users want to be able to click a plus sign to the left of the row like you can in excel and get a view of the underlying accounts (instead of drilling down/through). Is this possible to do in a non-paginated report?

Any tips gratefully received (see example expansion in the attached image)

example expansion

2

Try a matrix instead of a table.
Greg

1 Like
3

Thanks Greg, good point :slight_smile:

4

Hello @lvlandmark , good to see that you are having progress with your inquiry. Did the response from @Greg help you solve your inquiry?

If it does, kindly mark as solution the answer that solved your query.

If not, how far did you get and what kind of help you need further?

5

Hi @lvlandmark, we’ve noticed that no response has been received from you since a few days ago.

We just want to check if you still need further help with this post?

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.