Forum Discussion

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 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
    7 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.
     


     

4 Replies

  • mdaatifraza5556's avatar
    mdaatifraza5556
    Icon for Super User rankSuper User
    7 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.