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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jilek
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?

4 REPLIES 4
jilek
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.

v-yanjiang-msft
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:

vkalyjmsft_0-1658490974809.png

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

vkalyjmsft_1-1658491043202.png

And then filter the visual by the customer slicer.

vkalyjmsft_2-1658491129210.png

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.

 

 

jilek
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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors