Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Total Line Bar Chart

Hello, I have a database in which sales to different countries and in different years appear. I have created a graph with the TOP 4 countries to which the most quantity has been sold (on the 'y-axis...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Syndicate_Admin ,
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    1. Create a measure

    Total Sales = CALCULATE(SUM([Sales]), REMOVEFILTERS('Table'[Sales],'Table'[Year]))

    2.Choose Line and clustered column chart


    Final output

     

     

     

    Best regards,

    Albert He

     

    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 Syndicate_Admin ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

1. Create a measure

Total Sales = CALCULATE(SUM([Sales]), REMOVEFILTERS('Table'[Sales],'Table'[Year]))

2.Choose Line and clustered column chart


Final output

 

 

 

Best regards,

Albert He

 

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