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 have setup a power BI file using real time data from Microsoft forms, which is sent to Power BI through Microsoft flow. The flow is working fine but not sure how to display some data in Power BI correctly. Very new to DAX programming so if someone can help that would be great.
The data I would like to display comes from the question:
Which of the following occured on the project?
From the results I would like to display a graph or chart highlighting the total number of each option selected per month.
The problem I have is splitting and displaying the totals per month. I'm not sure if this is due to restrictions in dealing with real time data in Power BI, or my lack of knowledge in creating DAX measures. Pretty sure there should be a way. Any ideas welcome.
Hi @SimpoPower ,
As I know, we can use all the DAX functions in live connection mode. For your scenario, if you could share some sample data and your expected results, I think we might understand clearly and solve it quickly. Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hello Xue, thanks for responding.
I'll try to provide some more information to explain better. Let me know if anything doesnt make sense.
The question asked in Microsoft Forms is below:
The answers are retrieved in Microsfot Flow and sent through to Power BI. Below is a basic table from some sample data created in Power BI:
I am looking to put this information into a graph, showing a line for each option, indicating the percentage of the total for each option (Y axis), compared to the month (X axis).
For example on the chart above, assuming this was the full results for November, 'Client raised major issues' would be set to 75% on the graph for November. 'Client raised positive feedback' would equal 25%. This would continue for December, January etc.
The problem I am having is writing the DAX code to calculate the percentages of the totals. Also to create a total for each month.
Below is what happens when I add the data to a simple chart, but would require the DAX code to create new measures to total percentages from the text replies. Also to create percentage per month. Any ideas grateful.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |