Not reporting blank data when i use x axis with Quarterly date.

[rajendraongole1]

Hi

I am not getting all the data when i am using quarterly date on X axis

visual is coming with skipping the value which is not having the data and reporting with valued data.

I need to report in line chart with blank as zero for that quarterly.

i am using the condition as below when i select male & female some of the values are reporting properly but some not.

text= IF(OR(ISBLANK(table[column]),table[column]=0),"MALE","FEMALE")

 

Let me know if i need to add anything.

 

before that i have applied for that particular column with show item with no data also. but no luck.

 

i want to report all the quarterly data with 0 even it is blank without skip of that particular quarter.

 

Please suggest.

[rajendraongole1]

Hi 

As per attached chart., is there any way to report missed data points in line chart with "0" tried with show items with no data option for x axis. but not coming. Let know is there any way?

?

[rajendraongole1]

Thanks for the response..

I have written calculated column as below:

tablename[column] is numeric data.

IF(ISBLANK(tablename[column])||tablename[column] = 0 || tablename[column] = "","MALE","FEMALE")

 

in the above,facing err like integer value comparing with string which is not accepting it as new column. 

 

Any suggestions

[v-yuta-msft · Accepted solution]

@rajendraongole1 ,

Modify the measure:

result =
IF (
    ISBLANK ( tablename[column] )
        || tablename[column] = 0
        || tablename[column] = null,
    "MALE",
    "FEMALE"
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yuta-msft]

@rajendraongole1 ,

Modify the calculate column using dax below:

text =
IF (
    ISBLANK ( table[column] )
        || table[column] = 0
        || table[column] = "",
    "MALE",
    "FEMALE"
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.