Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to build a report that can collect some info from user (your city from drop down list, some number (eg family memebrs) and as the result provide some calcualtions or visualization relevant for his/her parameters.
So I need some input form to collect user data, than it will show calcualtion build based on user parameters and the data in the report. What would be the best option to do it in power BI?
thank you.
Solved! Go to Solution.
Thank you! Maybe I confised everyone. I found a simple solution. For City I created a visual filter (used list of cities in my data table). For the parameter I created a table with possible parameters values: 1 to 10000, then added a filter to the page that allows people to select the range for the parameter value or specific value. In calculations I use both filter results: City from first one and Average for parameter value.
Thank you! Maybe I confised everyone. I found a simple solution. For City I created a visual filter (used list of cities in my data table). For the parameter I created a table with possible parameters values: 1 to 10000, then added a filter to the page that allows people to select the range for the parameter value or specific value. In calculations I use both filter results: City from first one and Average for parameter value.
It depends on how you want to use it. If you want it to be real time (they input data, then the report works) then you have two options:
If it doesn't have to be real time, then Excel Forms is fine, or you can get a little fancy with Power Apps and use Excel, SQL, or pretty much anything (except Access) as a backend. Then just let them know it will show up on the next scheduled refresh.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |