Show null when there is no data in line chart

[Anonymous]

Dear friends 

from pic belows, how can i let blue line chart null if there is no data on axis value (3)

what i need

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Step1# 

Change the [Type] under [Format]->[X-axis] to "Categorical".

Step2#

Sort ascending the visual by Axis.

Result would be shown as below.

Best Regards,

Jay

[Anonymous]

Hello @Anonymous ,
You can sort by the total pallet in ascending order.
Try and check.

[amitchandak]

@Anonymous ,

Change measure like

if([measure] =0, blank(), [Measure]) 

And Try and check

[Anonymous]

@amitchandak its not worked 😞

[amitchandak]

@Anonymous , Change axis type to categorical and check

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak thanks for your advice but i tried , the axis not sort by ascending anymore.