Forum Discussion
How to visualize Multi-select questions as a bar graph?
Hi Anonymous ,
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 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 Anonymous ,
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.