Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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
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.