Forum Discussion
Remove zero value on Multiple line chart
Hi Team,
I want to remove zero values from multiple line chart specifically 2026 it should show till availabe data
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.
4 Replies
- mdaatifraza5556Super User
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.
- krishnakanth240Super User
- adityavighneContinued Contributor
mdaatifraza5556
Thank you. First one is useful - adityavighneContinued Contributor
krishnakanth240
Thank you for helping