How to visualize Multi-select questions as a bar graph?

[eeshatariq]

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!

[Anonymous]

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.

[Pragati11]

Hi @eeshatariq ,

Can you please post sample data here in order to understand your question properly?

Thanks,

Pragati

[eeshatariq]

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

[Anonymous · Accepted 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.