Forum Discussion

vjnvinod's avatar
vjnvinod
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://ww...
Need Help
Show and Tell
  • shebr's avatar
    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

     

     

shebr's avatar
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's avatar
    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's avatar
      shebr
      Resolver III
      8 years ago

      Hi vjnvinod

       

      I have had a good look around and dont see the option for that.

       

      Thanks

       

      shebr