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.

     

     

     

     

Priya1969's avatar
Priya1969
Resolver I
3 years ago

 

Are you ok with the below view?

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes, I can use this view. I guess you are performing group by with two attributes right?

  • Priya1969's avatar
    Priya1969
    Resolver I
    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.

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks a lot. That's what I just did a few minutes ago ^^ I also turn off the +/- icons for preventing end-users from performing any other interactions.

      But after expanding like that, are there any ways to customize the visualization of those expanded columns? For example, I want to highlight only the "Total members" column. I do not see any formats for supporting me to do this.

      • Priya1969's avatar
        Priya1969
        Resolver I
        3 years ago

        I don't think so we can do only highlight 'Total Column'. But we can do something like this.