Hi @harveychun ,

You can try to use AI/BI dashboards in Databricks SQL. There is a good article written by Cody Austin Davis that shows how combination of parameters and filters allows to create dynamic reports.
But keep in mind that reproducing complex DAX measures in Databricks SQL can be complicated and that the capabilities of databricks dashboards (which are getting better) are still pretty limited comparing to Power BI. 

Building Lakeview Dashboards on Databricks — Best Practices | by Databricks SQL SME | DBSQL SME Engi...