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.
How to extract the data completely from the matrix visual in a tabular form. So that I can use that summarise data in any form for lookup and other things dynamically.
The outputs are showing from measures.
You can export the data from the matrix visual, here for your reference:
Export data from a Power BI visualization - Power BI | Microsoft Learn
Once you have exported the data to Excel, you can use it for lookup and other dynamic purposes. You can further manipulate the data in Excel or import it back into Power BI for additional analysis.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a matrix from my Part Wise CS table In which
Rows Contains
1. Part Number
2. Part Name
Columns Contains:
Month
Values Contains
Qty
STDV ---------------Its a measure
Avg.-----------------Its a measure
Check---------------Its a measure
this is my check measure
Matrix visual and any other viz will export data of whatever field/measurs are added to it. So if you select only a few dimensions and a few measures , you'll get just those dimensions and measures. If you want the complete underlying data, all the dimensions and measures must be complely present in the viz.
@Arghya_Dutta Could you explain with the help of screen shots or dummy data?
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |