Forum Discussion
Matrix Table how to show row value repeatedly
Hi robAURECON ,
How about try to use the table visual if you do not have multi column header?
Best regards,
- robAURECON6 years agoFrequent Visitor
unfortunately i cannot use table, since I have column that is dynamic in number
- v-lid-msft6 years ago
Community Support
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, - v-lid-msft6 years ago
Community Support
Hi robAURECON ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,