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.
Hi,
I'm building a dashboard which displays the outputs of a survey which is completed via microsoft forms.
I have a power automate flow set up such that when responses are receieved, they are pushed to an excel which is connected to this dashboard.
Now on this dashboard, for a given visual, I'd like to introduce a target value showing how that client measured up against everyone else who filled out the survey - however I would like for this derived measure to be calculated automatically based on the responses submitted in microsoft forms.
To give an example lets say company x fills out this survey and their company name, x, is included in the response form. I then have a guage visual which gives an average score for let's say environmental policy across all companies who filled out the form. I want to display company x's score for environmental policy on this same visual automatically when their reponse is pushed to the excel so that this can then be mailed back to them.
Any advice on how I might approach this?
Thank you in advance!
@Anonymous , not very clear to me, but see if power app can help you
https://www.youtube.com/watch?v=LxuRzj0X348
HI @Anonymous,
>>for a given visual, I'd like to introduce a target value showing how that client measured up against everyone else who filled out the survey - however I would like for this derived measure to be calculated automatically based on the responses submitted in microsoft forms.
I think you need to design a user mapping table to mao records with username, then you can write measure formula with 'username' function to get current user records dynamically and compare with of total users records.
Using Username() in DAX with Row-Level Security
Regards,
Xiaoxin Sheng
Covering 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |