cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kasireddyvina
Helper I
Helper I

Displaying "No Data" along with Y axis values

Hi,

when am displaying "No data" text for few visuals its displaying "NO data" along with Axis Values as below:

 

Kasireddyvina_1-1616563731887.png

 

where in the first visual showing Y axis values but in the 2nd visual its just plan (without Y axis values) as expected.

Measures used for 1st & 2nd Visuals:

Nodata 1st = IF (
CALCULATE ( DIVIDE(
CAP[CAP Last 4 Qtr ontime],CAPA[CAP Last 4 Qtr Due])) = BLANK (),
"No Data","")
 
Nodata  2st = IF(ISBLANK(CAP[CAP >50 % Delayed]),"No Data","")
 

 

May i know y this is happening from visual to visual?

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Kasireddyvina , Try the first one also with isblank.  <> Blank() is good choice or isblank

 

Nodata 1st = IF (isblank(
CALCULATE ( DIVIDE(
CAP[CAP Last 4 Qtr ontime],CAPA[CAP Last 4 Qtr Due])) ),
"No Data","")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@Kasireddyvina , Try the first one also with isblank.  <> Blank() is good choice or isblank

 

Nodata 1st = IF (isblank(
CALCULATE ( DIVIDE(
CAP[CAP Last 4 Qtr ontime],CAPA[CAP Last 4 Qtr Due])) ),
"No Data","")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Hi Amit,

 

Tried as you mentioned, but still as same with y axis values?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors