Forum Discussion

Krishna_Mysore's avatar
Krishna_Mysore
Icon for Helper II rankHelper II
8 years ago

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 b...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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)

     

    Solution:

     

     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.