Forum Discussion
Matrix Table how to show row value repeatedly
Hi,
Im currently working on table matrix, is there a way that i can show the first few row value repeatedly instead of once?
In example in below table, under Portfolio column value BTE is only shown once for all records associated with in for Project, Phase and Task however our client wants to see the BTE to shows per row. Same with Project, Phase and Tasks column
4 Replies
v-lid-msftCommunity Support
Hi robAURECON ,
How about try to use the table visual if you do not have multi column header?
Best regards,unfortunately i cannot use table, since I have column that is dynamic in number
- v-lid-msft
Hi robAURECON ,
Sorry for late reply, based on my research, In Matrix visual, repeated values will be grouped and hided automatically. But we can add a distinct value at the begining of Rows field.
First of all, we generate a calculated column in fact table using Rankx function:
RowRank = RANKX ( 'Table', [Level1],, ASC, DENSE ) / DISTINCTCOUNT ( 'Table'[Level1] ) + RANKX ( 'Table', [Level2],, ASC, DENSE ) / 10 / DISTINCTCOUNT ( 'Table'[Level2] )Then we can format it as empty to hide it and put it into the row field:
After close the Word Warp for Colmun header in settings, we can hide the entire column by resize the width.
If it does not meet your requirement,perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas
You could also create your own custom visual if you are an experienced web developer: https://powerbi.microsoft.com/en-us/documentation/powerbi-custom-visuals/
Best regards,
