Forum Discussion

adkjfhasdf12440's avatar
adkjfhasdf12440
Frequent Visitor
2 years ago
Solved

Line Y-Axis not charting properly

i'm creating a line and stacked column chart using this data:   i changed the Source.Name (dates) to week #s in order to determine "Last Week (balance)". Then i used the below formula to dete...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi adkjfhasdf12440 ,

    Based on the description, try to use the following DAX formula. Create the wow column.

    Wow balance change = 'Table'[Total Balance] - 'Table'[Last Week]

    Then, drag the wow column to the Line y-axis. Drag the date to the X-axis.

    The line graph is plotted as wow balance.

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi adkjfhasdf12440 ,

Based on the description, try to use the following DAX formula. Create the wow column.

Wow balance change = 'Table'[Total Balance] - 'Table'[Last Week]

Then, drag the wow column to the Line y-axis. Drag the date to the X-axis.

The line graph is plotted as wow balance.

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.