Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replace (BLANK) with "No Data"

Hi,   So I have a report with around 40 measures, it's basically 99% done. I was just wondering if there was a way (without measure) to replace the default value of "(BLANK)" with a more meaningfu...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , as of now there is no such default option.

    1. You can add +0 or use coalesce([Measure],0) they will force left join (you will see all dimension value

    2. You can use if, same it will force left join

    3. Any other formatting like "No value" (using if), you need to change the format to text.

Daviejoe's avatar
Daviejoe
Icon for Memorable Member rankMemorable Member
6 years ago

If you are talking about your individual measures, you could add +0 to the end of your measures (add after you have closed off the last bracket.)

 

So instead of '(blank)' your measure will return a zero.