Forum Discussion

Gtzimas's avatar
Gtzimas
Frequent Visitor
6 years ago
Solved

Line chart with different date start from the same point

 

Hello everyone ,

 

I would like to ask your help , I have the following table :

 

 

with different date start for different data . As you can see below and i would like to start all data from the same point

 

any suggestion will be usefull.

Thanks in advance

Need Help
Tips and Tricks
  • Gtzimas's avatar
    Gtzimas
    6 years ago

    solution found , new column in the database added with the minimum date , then a new column on the power bi added calculated the day start from the current day count on days.

2 Replies

  • Gtzimas's avatar
    Gtzimas
    Frequent Visitor
    6 years ago

    solution found , new column in the database added with the minimum date , then a new column on the power bi added calculated the day start from the current day count on days.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    So, should those show zero then? Perhaps:

     

    RETURN

    IF(ISBLANK([Column/Measure/Calculation/Var]),0,[Column/Measure/Calculation/Var])