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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
adrianhalid
New Member

Use the data in a report as a dataset for another report

Is it possbile to use a report as a dataset for another report.

 

I have created a matrix report with what I need my dataset to be.

I now wish to use this Matrix report as my dataset for another report. Is this possible?

 

For example the Matrix report is created by using the distinct count rules so in the end I get a list of distinct values given certain filters. I get a report like this.

 

ABC   1

DEF   1

GHI   1

JKL   1

MNO   1

 

Total 5

 

I basically want to then use this data and create a new report where I can then filter on different conditions.

1 REPLY 1
MattAllington
Community Champion
Community Champion

See my note in the other post. It is the same process for desktop and the service. 

Select the report

click edit at the top

Add a new tab by clicking + at the bottom



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors