Forum Discussion

Impactful Individual

8 years ago

Solved

(Blank) in Multirow Card

Hi,

I am getting (Blank) in my visualization, while i am not sure how do i take that out from the visulazation.

Look at my scrubbed PBIX file, can someone please help to fix this?

https://www.dropbox.com/s/9j5asfq7xpdt0go/testchecknew.pbix?dl=0

shebr
8 years ago
Hi vjnvinod

See code and image below. It would be useful to you if you created measures from your values. This will help you handle blank values.

New Inbound Revenue = IF(ISBLANK(sum(Inbound[TER_FYTD_USD])), "", sum(Inbound[TER_FYTD_USD]))

Let me know how you get on,

Thanks

shebr

3 Replies

shebr
Resolver III
8 years ago
Hi vjnvinod

See code and image below. It would be useful to you if you created measures from your values. This will help you handle blank values.

New Inbound Revenue = IF(ISBLANK(sum(Inbound[TER_FYTD_USD])), "", sum(Inbound[TER_FYTD_USD]))

Let me know how you get on,

Thanks

shebr
- vjnvinod
  Impactful Individual
  8 years ago
  shebr
  
  Thanks, this helps, can you see, if we can convert the numbers to Millions or Billions as the same feature is missing in the Multirow card.
  
  Regards, vinod
  - shebr
    Resolver III
    8 years ago
    Hi vjnvinod
    
    I have had a good look around and dont see the option for that.
    
    Thanks
    
    shebr