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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vshiva
Frequent Visitor

Filtering at Source

I am creating a dashboard which will be used by 100+ users. 

 

Context: I have 10M rows with 30+ columns of data in Oracle / SQL DB. I need to filter them at the source (before loading into Power BI) to improve my dashboard performance.

 

Need: I have to filter them based on multiple conditions (Min 3 nos) which can be from either a single column or across multiple columns.

 

My users are not much familiar with Power BI and I need to simplify their filtering process. I am thinking of below two options. (Not sure about the Feasibility though)

 

1. Give them this as a filtering option in the Dashboard itslef. i.e., User can input / select the criteria from a dropdown list.

 

2. Use some buttons in the Power BI Dashboards to do this?

 

Request to kindly shed some light on this.

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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