Forum Discussion

chrispino1913's avatar
chrispino1913
New Member
1 year ago
Solved

3 data in chart

Please tell me how I can display the 2023 actual sales separately instead of calculating them as part of the total actual sales for 2023 and 2024.

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, chrispino1913 

    Thanks for the reply from MattiaFratello. You can refer to his reply, or try to use  some measures to achieve your need.

    2023Actual = SUMX(FILTER('Table','Table'[Year] = 2023 && 'Table'[Attribute] = "Actual"),'Table'[Value])

2023Target = SUMX(FILTER('Table','Table'[Year] = 2023 && 'Table'[Attribute] = "Target"),'Table'[Value])

2024Actual = SUMX(FILTER('Table','Table'[Year] = 2024 && 'Table'[Attribute] = "Actual"),'Table'[Value])

2024Target = SUMX(FILTER('Table','Table'[Year] = 2024 && 'Table'[Attribute] = "Target"),'Table'[Value])

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

4 Replies

    • chrispino1913's avatar
      chrispino1913
      New Member
      1 year ago

      Is it possible to use a combo chart? If we use small multiples, the data charts will not be on a single dashboard/axis. By having them on the same axis, the data will be easier to compare

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, chrispino1913 

    Thanks for the reply from MattiaFratello. You can refer to his reply, or try to use  some measures to achieve your need.

    2023Actual = SUMX(FILTER('Table','Table'[Year] = 2023 && 'Table'[Attribute] = "Actual"),'Table'[Value])

2023Target = SUMX(FILTER('Table','Table'[Year] = 2023 && 'Table'[Attribute] = "Target"),'Table'[Value])

2024Actual = SUMX(FILTER('Table','Table'[Year] = 2024 && 'Table'[Attribute] = "Actual"),'Table'[Value])

2024Target = SUMX(FILTER('Table','Table'[Year] = 2024 && 'Table'[Attribute] = "Target"),'Table'[Value])

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum