Hiding missing values in a line chart (direct query)

[PBNikr]

I would like to hide certain values in a line chart. Is there any way to do this?

As you can see in the line chart below there are values missing for "Value" and these disappear when "Average" is removed from the chart. We would however like to keep "Average" in the chart and just hide the missing values for "Value" somehow.

Can this be done?

[v-juanli-msft]

Hi @PBNikr

Could you show some data for better analysis?

Such as the columns in the X-Axis, Value field, legend field?

Best Regard

Maggie

[PBNikr]

Hi @v-juanli-msft!

I have attached a table with sample data:

As you can see, the gaps in data occur on weekends. I am connected to a model using Direct Query and am therefore limited to what I can alter directly in Power BI. 

[v-juanli-msft]

Hi @PBNikr

It seems you face the similar problem like line chart not representing null values, you could create a measure to replace "Value" .

Measure = IF(MAX([value])=BLANK(),0,MAX([value]))

Best Regards

Maggie