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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.