Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mrothschild
Continued Contributor
Continued Contributor

Line Chart incorrect data being displayed

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!

 

mrothschild_1-1628006238684.png

 

 

 

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

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.

39.png

 

 

Best Regards,
Community Support Team _ Eason

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.

 

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors