Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vjnvinod
Impactful Individual
Impactful Individual

(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

1 ACCEPTED SOLUTION
shebr
Resolver III
Resolver III

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

 

Revenue.JPG

 

View solution in original post

3 REPLIES 3
shebr
Resolver III
Resolver III

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

 

Revenue.JPG

 

vjnvinod
Impactful Individual
Impactful Individual

@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

Hi @vjnvinod

 

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

 

Thanks

 

shebr

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.