Forum Discussion

adityavighne's avatar
adityavighne
Continued Contributor
6 months ago
Solved

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  
Need Help
  • mdaatifraza5556's avatar
    mdaatifraza5556
    6 months ago

    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.
     


     

mdaatifraza5556's avatar
mdaatifraza5556
Super User
6 months ago

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.