Forum Discussion
Matrix Table how to show row value repeatedly
unfortunately i cannot use table, since I have column that is dynamic in number
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,