test_Subgroup.pbix (25.3 KB)
I have a question. I am trying to create a table that will have columns stacked underneath one another. My actual data is very big in size and is coming in from the server. I know that I could create the tables and stack them underneath one another, however, I have been asked to do it in a certain way. And, I have never worked with data manipulation to such circumstances before, so any kind of help would be appreciated.
I am attaching the file here. You will be able to see that I have 3 tables stacked underneath one another. I did try creating queries with conditional columns for each subgroup type and append them afterward. But, it would not work much since my dataset has over a million records. However, I am trying to create a table that would look more like this: