Forum Discussion

Rob92's avatar
Rob92
Frequent Visitor
2 years ago
Solved

Filter visual using dynamic aggregate calculation that references other slicer defined values

Our dataset looks at loans.  I have a matrix that looks at average interest rate per county.  I currently have three slicers working on it - Date, Interest Rate, Loan Amount.  These work on the row l...
Need Help
  • Rob92's avatar
    Rob92
    2 years ago

    I think I've found my solution!!  I'm yet to implement it, but in principle I can't see why it won't work:  Integrate a Power App into the Power BI report that writes user input back to the data source and updates with Direct Query in real time:  https://www.youtube.com/watch?v=us0hPFwQ4Zs

    Will report back with anything noteable once I've put this into practice.

Rob92's avatar
Rob92
Frequent Visitor
2 years ago

I think I've found my solution!!  I'm yet to implement it, but in principle I can't see why it won't work:  Integrate a Power App into the Power BI report that writes user input back to the data source and updates with Direct Query in real time:  https://www.youtube.com/watch?v=us0hPFwQ4Zs

Will report back with anything noteable once I've put this into practice.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Note that this will require all your report users to have a PowerApps Premium license.