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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

Need help with custom reporting

So I have a large dataset for my customers, the issue I am trying to overcome is that they all come to me with a list of contract numbers for whichever account they are interested in at that time.  They are looking to filter this dataset by those provided contract numbers and export that data.  How do I ingest that list from them and then have it filter that data for them on demand?

New Member

@amitchandak - I am sure that there will be some sort of power automate or scripting that will have to be done to acheieve this.  I am just trying to figure out that plan as I have never had to do something like this.


@v-yanjiang-msft - I did start out with your suggested route, but it got to where there were so many duplicate contract numbers that the customers would provide for me that I told them until they can get me a good list this wont be an option.

For now I was trying to give them some sort of custom on demand reporting that would allow them to provide the contract numbers and then select the reporting period they are looking for and the tool/utility would provide them the .csv or whatever with that data.

Community Support
Community Support

Hi @jilek ,

If you don't want to search each contract number and select them in the slicer, at least the customer should have a list about which contract numbers they prefer to give you. Then you can create a new table by it like this:


Create relationship to the fact table with the contract number column.


And then filter the visual by the customer slicer.


Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



New Member

just to add, these are large lists of contract numbers, a pain in the @$$ to select each one manually in a slicer.  

@jilek , I think you should if power automate can help in this case

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.