Forum Discussion
How to pull/scrape data from a Visual to a table?
I have a question that I am at a loss to solve at the moment. I'm hoping this audience may be able to provide some insight.
Background Info:
Data Sources
- Source #1: A static list that I use to map the first 3 octets of the machine IP Addresses to Site names.
- Source #2: A daily report with machines and scores.
- Source #3: A copy of the daily report from the previous week for historical comparison, this is typically 1 week old.
- The daily reports list all machines in the environment will multiple data points. Given the nature of this report, a machine can be listed 1 to 100 times.
Data Mapping
- Source #1 (static Locations) <-> Source #2 (daily report) based on IP Concat
- Source #1 (static Locations) <-> Source #3 (historical report) based on IP Concat
- IP Concat is the first 3 octets of the IP address in the daily report to map against my static Locations list.
The visual I am using:
It is a Matrix visual with the following columns.
- Location (from Source #1 which is my static location list)
- Source #2 Sum of all machine scores
- Source #2 Avg of all machine scores
- Source #3 Sum of all machine scores
- Source #3 Avg of all machine scores
Example:
Location | #2 Sum | #2 Avg | #3 Sum | #3 Avg |
----------------------------------------------------
Site A 999.22 5.97 1300.10 7.52
#2 = Source #2 and is the current daily report
#3 = Source #3 and is an old copy of the daily from last week
My Question:
What I want to be able to do is to use conditional formatting to visually indicate the rise, equal (no change), or fall of the Avg scores in the Matrix visual.
Location | #2 Sum | #2 Avg | #3 Sum | #3 Avg | Difference |
----------------------------------------------------------------
Site A 999.22 5.97 1300.10 7.52 -1.55 ↓
Is there a way to pull/scrape the data from this Matrix visual into a table? If yes, I know I can get the difference between the 2 columns and then create the conditional formatting I am looking for.
Recreating the Matrix visual through DAX or other means will be a major challenge. I have the static list because the source system has incomplete mappings for IP to site names, so garbage is what we usually get. It is a known issue nobody seems to care about, hence the creation of a static list to get usable data.
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.
5 Replies
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.
Thank you. I expected this to be the answer.
This will be an opportunity to further my knowledge in Power BI then!
Hi MattinFlyOvaUSA You can export up to 150,000 data intersections from matrix visuals using "Data with current layout"
Steps:
- Right-click on your matrix visual → "More options" (…) → "Export data"
- Choose from:
- "Data with current layout" - preserves the matrix structure
- "Summarized data" - exports as flat table
- "Underlying data" - gets raw data (if permissions allow)
For more details: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-service
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
Can that be done within the Power BI, meaning instead of a sheet for Excel it is a table in Power BI where I can make additional changes?
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.
