0

blank row in between different values

Is it possible to add blank rows in the tables? i.e. show 3 value measures, have a blank row then another 3 value measures?? 

 

So I have a table which shows increased, reduced, unchanged, then goes onto show data points for renewal, new etc. but they want it in a single table rather than two separate tables? Could i create a blank measure to add between them?

 

Thanks

 

Nick

1 reply

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 yrs ago
    • Reported - view

    Hi Nicholas,

    Yes. Here's an example. I've created a custom measure called null, set to null.

    A few things to note:

    1. I've used specific row formatting for the null custom measure, setting the Row label text colour to match the background (white in this case).
    2. You'll need to set Readability to 'Off' for this to take effect.
    3. You'll need to set 'Show Empties' to 'On' in the Query Ribbon to show the blank line.

     

    Hope that helps.

    Ian

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 1Replies
  • 26Views
  • 2 Following