Forum Discussion

Maria123's avatar
Maria123
Regular Visitor
8 years ago

Fill gaps in Line chart

Hi!   I have some troubles. Lets say that I have some information per sales week. I have two type of product categories, A & B. A is shown as column values and B is shown as line values. Some weeks...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Maria123,

Assume that  your original table is as follows. You can create the measures below in your table and then create the expected chart.



Product A = CALCULATE(SUM(Table[margin]),FILTER(Table,Table[Product]="A"))
Measure 3 = CALCULATE(SUM(Table[margin]),FILTER(Table,Table[Product]="B"))
Product B = IF(ISBLANK([Measure 3]),0.3,[Measure 3])



Regards,
Lydia

  • Maria123's avatar
    Maria123
    Regular Visitor
    8 years ago

    Hi!

     

    Thanks for the help! However, the data is refresh each sales week and therefore I don't want to have a fixed amount in my calculation. So I would like to have a dynamic way where it automatically fill the blanks so I can have a line chart for Product B.

     

     

    Maria

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Maria123,

      Power BI doesn't provide the  “Connect data points with the line”  option like Excel. The workaround to get a continuous line is to create a measure as described in my first reply, for the fixed amount 0.3, you can replace it with another measure which calculates dynamic value.

      Regards,
      Lydia