Remove zero value on Multiple line chart

[adityavighne]

Hi Team,
I want to remove zero values from multiple line chart specifically 2026 it should show till availabe data

[adityavighne]

@krishnakanth240 
Thank you for helping

[adityavighne]

@mdaatifraza5556 
Thank you. First one is useful

[mdaatifraza5556 · Accepted solution]

Hi @adityavighne 

Could you please try the below measures.

I am assuming you are calculating sales.

Sales =
VAR _sales = SUM(FactSales[SalesAmount])
RETURN
IF(
_sales = 0,
BLANK(),
_sales
)

OR You can try the second measure

Sales (Till Today) =
IF(
MAX('Dim Date'[Date]) > TODAY(),
BLANK(),
SUM(FactSales[SalesAmount])
)

If neither of these works, please provide more context about your requirement.

If this answers your question, kindly accept it as solution and give kudos.
 

[krishnakanth240]

Hi @adityavighne 

Can you try this measure

Display= IF([Actual Value] = 0, BLANK(), [Actual Value]

)