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 everyone,
I want to visualize several questions which have the option of multi-selecting answers. For example a question asks to choose the qualities of a leader and there are several options to choose from and people select 3 each, I want the graph to appear as such on Power BI: (BTW this data I am getting live from KoboToolbox)
Thanks in advance!
Solved! Go to Solution.
Hi @eeshatariq ,
So you want to show top3 quantities for each leader?Try RANKX() function or TOPN filter.
https://docs.microsoft.com/en-us/dax/rankx-function-dax.
Is your sample data the expected result or the raw data? Better to show sample data and expected out put to us if you don't have any Confidential Information.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @eeshatariq ,
There're two common way to do that.
1# Add fields to filters, in your scenario add qualities to filters.
For more details about filters in Power BI please check the document below.
https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter.
2# Create slicers with fields, in your scenario use qualities as a slicer.
For more details about silcers in Power BI please check the document below.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @eeshatariq ,
Can you please post sample data here in order to understand your question properly?
Thanks,
Pragati
HI @Pragati11 the sample data is as follows; the question is the header and below are the options people have selected (3 each exactly):
18. Choose top 3 qualities of a good leader |
Vision Integrity Humility |
Vision Integrity Humility |
Vision Integrity Humility |
Vision Focus Courage |
Vision Cooperation Strategic planning |
Vision Focus Strategic planning |
Vision Integrity Strategic planning |
Confidence Cooperation Humility |
Vision Confidence Humility |
Vision Focus Integrity |
Vision Confidence Strategic planning |
Vision Confidence Integrity |
Vision Cooperation Strategic planning |
Vision Integrity Humility |
Vision Confidence Humility |
Vision Confidence Courage |
Vision Courage Strategic planning |
Confidence Courage Strategic planning |
Vision Focus Humility |
Focus Cooperation Strategic planning |
Vision Integrity Strategic planning |
Vision Cooperation Strategic planning |
Hi @eeshatariq ,
So you want to show top3 quantities for each leader?Try RANKX() function or TOPN filter.
https://docs.microsoft.com/en-us/dax/rankx-function-dax.
Is your sample data the expected result or the raw data? Better to show sample data and expected out put to us if you don't have any Confidential Information.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |