Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
5 months ago
Solved

Emty row in custom field

I want to create custom tables, so I created a table called “Marge” with the fields I want to display, including an empty row. When I create a “switch - measure,” the empty row disappears. How ...
  • DanieleUgoCopp's avatar
    5 months ago

    Hello,
    I’m not completely sure, but this usually happens because the measure returns BLANK for that row, so Power BI just hides it by default

    you could try forcing the measure to return something instead of BLANK, like 0 or even an empty string, that often keeps the row visible, another option is turning on “Show items with no data” in the visual if it fits your setup

    if you’re using a switch measure, sometimes wrapping it with COALESCE helps to avoid blanks and keep all rows

    not super clean, but usually one of these works

    Best regards,
    Daniele

  • Moniek's avatar
    4 months ago

    Hi, In addition to leaving a blank row, I’d also like to make some fields bold or a different color. Can you do that with a custom table? For example, can you specify the type as “heading,” and if it’s a heading, have it appear in bold or a different color in the table?

    And indent it like in the screenshot?