Forum Discussion

sea's avatar
sea
Frequent Visitor
8 years ago
Solved

compare value year

Hello

 

I have the following table:

 

+------+-------+
| year | value |
+------+-------+
| 2016 | 456.0 |
| 2016 | 100.0 |
| 2017 | 80.0 |
| 2017 | 123.0 |
+------+-------+

 

How could I compare in a Power BI graphic/chart ( type clustered column chart) the years and sum up the values?

 

Thank you!

  • Hi sea,

     

    Add the [Year] field into Axis section and place [Value] field into Values section of the chart visual.

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi sea,

     

    Add the [Year] field into Axis section and place [Value] field into Values section of the chart visual.

    Best regards,

    Yuliana Gu