Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |