Line Chart incorrect data being displayed

[mrothschild]

PBIX file: https://drive.google.com/file/d/1j_4CrUj0fPh0xK6hnO7OZ-uIWkoP5Kdg/view?usp=sharing

The Line Chart shown below comes from the exact same single [measure] populating the Matrix that's above it.

You'll note from the Matrix, that the rows associated with [Upside], [Downside], and [Expected] are different for each associated year, as intended.  But when this [measure] is put into the "Values" section for the Line Chart visual, the numbers are all identical, resulting in 3 lines that lay on top of each other.  How can I graph the data as shown in the Matrix?

Thanks!

[v-easonf-msft]

Hi ,  @mrothschild 

Not  clear about your question. Can you explain the function of __SINGLE MEASURE (Graph) in detail?

In addition, in the pbix file you provided, the line chart seems to report an error and does not show any results.

Best Regards,
Community Support Team _ Eason

[mrothschild]

Yes, the Line Chart is throwing an error, because of some of the ways I've tried to find work around solutions.  A more detailed description of those errors is available from a different forum question I posed found here: https://community.powerbi.com/t5/Desktop/Errors-from-SQRT-POWER-or-even-using-for-data-that-doesn-t/...

The purpose of SINGLE MEASURE was from an answer I received to this question in the forums: https://community.powerbi.com/t5/Desktop/Slice-Matrix-rows-using-the-names-of-its-measures/m-p/19954...

It's designed to create a measure that's sliceable on the Matrix using disconnected slicer table based on the "Criteria" name.  In this specific case, I'm trying to show on the Matrix data rows that include the following five "Criteria": Upside, Actual, Expected, Downside, Y/Y%.  This way, my users can drill up or drill down in the Matrix table.