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?
=> 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.
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.
Please refer to my original post with images where I have highlighted the matrix table where I have inserted dots as field name under the KPI Table. This enabled me to insert blanks in the matrix table, howerver is there an option to get away by not inputting dots yet insert blank?
Hope this is clear!
I was going through your post and observed the sample PBI file shared.
Need help on a similar scenario where i need to display the Blank rows in Matrix Visual. I have posted my request and below is the link.
I have explored and Found solution to display the blank rows in the Matrix visual ( i.e. display the rows which has no values)
Refer the post i submitted for more details (https://community.powerbi.com/t5/Desktop/Need-help-on-designing-Visual/m-p/561243#M264742)
Rows --> select the Row field and right click and choose "Show items with no data" option.
Same applies to,
Columns --> select the Column field and right click and choose "Show items with no data" option.
Refer the below working visual:
Item5 has blank values but still the entire Item5 Row is displayed in the Matrix visual.