Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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!

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

4 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

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

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    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.