Creating an expandable table in PowerBi Desktop
Budget: $10 – $30 USD
Hi
I have an exceltable with 10 columns and approx 5k rows. I want a matrix table in PowerBI where all the identical ID-Tags from column A are summarized (collapsed) with the remaining columns empty. Upon clicking the expanse +, all rows which carry the unique ID-Tag collapsed before should be visible including the variables in the rows that were hidden before. Important: I only want two levels of hierarchie - one for the summarized ID-Tags and one with all data after expanding the collapsed rows.
Also, I want a description how to do it, I dont want just the result.
I have an exceltable with 10 columns and approx 5k rows. I want a matrix table in PowerBI where all the identical ID-Tags from column A are summarized (collapsed) with the remaining columns empty. Upon clicking the expanse +, all rows which carry the unique ID-Tag collapsed before should be visible including the variables in the rows that were hidden before. Important: I only want two levels of hierarchie - one for the summarized ID-Tags and one with all data after expanding the collapsed rows.
Also, I want a description how to do it, I dont want just the result.