Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |