How to pull/scrape data from a Visual to a table?

Hi MattinFlyOvaUSA ,

Thank you for reaching out to the Microsoft fabric community forum.

As Royel  mentioned, exporting data from the Matrix visual is indeed possible and can be useful if you want to analyze the results externally in Excel. However, within Power BI itself there isn’t a way to directly “scrape” values from a visual into another table.

To achieve your requirement of comparing averages and applying conditional formatting inside Power BI, the recommended approach is to recreate the logic through DAX measures. For example, you could create measures for Current Avg, Previous Avg, and a Difference measure ([Current Avg] - [Previous Avg]).

You can then add this Difference measure into your Matrix or a Table visual and apply conditional formatting (icons, colors, etc.) to show increase, decrease, or no change.

This way you can stay fully within Power BI without needing to export, while still highlighting the rise or fall in scores as you intended.

Thank you.

I actually found a much simpler solution. I created my visual a Table consisting of Location, Score Sum for Today, and Score Sum for a Previous date. 

With that table in the Report View, click on the 3 dot menu, and select Show as a table. In the white space at the bottom to the right of the table, select New visual calculation and then Custom. From there, it is a simple formula of Difference (Sum) = [Current Sum] - [Previous Sum].

Hope this helps someone else down the road.