Forum Discussion
Need help to insert space (Blank Row) in a Matrix Visual
Hello
I have matrix visual with metrics on the Rows as shown below. This matrix is sourced from a Table called KPI .
I would like to have blank space after each category . This I have achieved by inputting a set of periods after each category .
The matrix visual now gives a blank row as I wanted but the row category with the spaces does not appeal hence I'm seeking a more elegant way of inserting a blank . Any ideas?
Regards
K
10 Replies
Hi Krishna_Mysore,
=> This I have achieved by inputting a set of periods after each category .
What is the category? What's the relation between category and table KPI?
Could you please share us your pbix file with OneDrive or Google Drive if possible? It will help us more to understand your requirement.
Thanks,
Xi Jin.Hi v-xjiin-msft
Link to the PBIX file
https://1drv.ms/u/s!AilocBFrwwn5gSJbe0MXicxDvl7b
Thanks
Krishna
Hi Krishna_Mysore,
First, thanks for sharing your pbix file.
However I still don't understand about "This I have achieved by inputting a set of periods after each category. The matrix visual now gives a blank row as I wanted but the row category with the spaces does not appeal".
What are the categories? Did you mean [Site Description]? For your current Matrix, you can select the Expand all down one level in the hierarchy option to display the [Site Description]. And the blank space is still here.
Thanks,
Xi Jin.
Hi averybody,
I am facing today the exact same issue and the solution of Anonymous does not correspond to my issue as it does not display a blank in Row headers. As I need a blank to separate two groups of lines in the matrix as a format trick. Does anybody knows how to insert a total blank row (header included)?
Many thjanks!
Best,
Léa
Do you find any alternative solution you are looking for to insert a blank row in between the categories? or else can you please direct me how you have done with -------. Thanks
Anonymous
I did a work around to resolve this.
1) Where ever I needed a blank space, I created row header with some characters either dots or * so that I have unique row header.
2) As these appears on the matrix when you place them under Rows, I have used text boxes on the matrix visual to hide them.
Hope this helps.
Hi!
Thanks for the answer. I can indeed do that for some tables! However it does not work for tables that are dynamic and which number of rows change depending on filters.
Best,
Léa
