Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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
Icon for Resolver III rankResolver 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
    Icon for Impactful Individual rankImpactful 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
      Icon for Resolver III rankResolver III
      8 years ago

      Hi vjnvinod

       

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

       

      Thanks

       

      shebr