Creating variance within each metric grouping

EDNA Forum Good Day!

What I’m trying to accomplish:

Per the layout in the screenshot below, I’m trying to get the data in the sample .pbix attached to display the same way.

Actual - in the screenshot is the CY - Current Year
Looking visual the shows CY PY and vs PY for each category
Please advise of any additional questions.
Much appreciate your time!
Thank you!


eDNA Solution - Sample Data Measures for CY_PY_Updated.pbix (110.4 KB)

Hi @ambidextrousmentally

Due to inactivity, we’d like to conclude that your inquiry was out of the experts and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!