Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Custom Matrix for displaying data as cohort visualization

Dear all, I am having a table on Power BI having the structure like this:   I want to use matrix and custom it to receive the desired output like this one (it can be understood as cohort vis...
Need Help
  • Priya1969's avatar
    Priya1969
    3 years ago

    Thanks!   Once you added, 'Week' and 'Total members' in the row,

    1. Select the format pane, expand the row headers, off the stepped layout.

    2. On the top, select Data/Drill option, then click the expand next level button.

    You will get the desire output.

     

     

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Create a new table with Values  1,2,3 and total as Text and another column as 1,2,3,0 (as the sort column)

 

Join it with the index and then change the formula for total

refer

Power BI - Show Grand total row or Avg Grand total row in Visual: https://youtu.be/OSwRZ4GUhxc

(You should able to do with one dimension you do not need 2nd dimension)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your suggestion. But I have some comments as below:
1. I think that it would not be an optimal solution since the data must be changed / updated day by day, which means the index will be always increased, and we cannot know the exact number of indexes to create in the temporary table. So performing hard-coding the temporary table should not be the way to solve this problem.

2. There's no need to perform any calculations or change the formula since the column "Members" has already been calculated in the data. My problem is just how to transform the data that I have in the table given into the desired output.