Forum Discussion

RenanPNog's avatar
RenanPNog
Icon for Helper I rankHelper I
2 years ago

Problem on trying to show 0 when BLANK

Hello everyone! So, i'm having a tough time on trying to display 0 when my measure results in BLANK. I'm also attatching the powerBI file here so you guys can fully comprehend what i'm seeking......
Need Help
Tips and Tricks
ajohnso2's avatar
ajohnso2
Icon for Solution Supplier rankSolution Supplier
2 years ago

It looks like you changed your aggregations on the visual only??

See below:

Please ensure you spend more time checking your model is correctly 'modelled' before moving onto reporting. I.e setting/checking datatypes, integer ID's should never be set as sum. 

 

Andy

RenanPNog's avatar
RenanPNog
Icon for Helper I rankHelper I
2 years ago

Hi, Andy!

That's weird.... because the new link is supposed to have this corrections. Check it out:

What am i missing?

  • ajohnso2's avatar
    ajohnso2
    Icon for Solution Supplier rankSolution Supplier
    2 years ago

    Please move your page level filter to filters on the visual as per below.

     

    • RenanPNog's avatar
      RenanPNog
      Icon for Helper I rankHelper I
      2 years ago

      Follows:

       

    • RenanPNog's avatar
      RenanPNog
      Icon for Helper I rankHelper I
      2 years ago

      Any news? As it looks on my last screenshot, i moved the filters, but still not working.

      I found some videos on youtube but they are not really good, it seems that forcing to appear zero results in this error always and i would probably need a big and complex turnaround to fix this