Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi everyone,
I am working on a project in Power BI where I am taking an excel document where people picked their favorite applications in office but it could have been multiple choice. An example would be
Name | Favorite Part of Office |
John | Outlook;Word |
Jane | Word |
What is the best way to report on their favorite part of Office under one graph? Currently in PowerBI it will make "Outlook;Word" one selection so depending on the order they checked the answers it gets really messy really fast.
Solved! Go to Solution.
Hi @TRISTANCARY
I created a sample ,maybe you can refer to it .
Original Date:
(1)Use Split Column in Query Editor , to divide a column of values into multiple columns of single values according to the separator, like this
(2)Return to desktop view ,and create measures to count the rows for each part .
Word = COUNTROWS(FILTER('Table','Table'[Favorite Part of Office.1]="Word" || 'Table'[Favorite Part of Office.2]="Word" || 'Table'[Favorite Part of Office.3]="Word"))
Outlook = COUNTROWS(FILTER('Table','Table'[Favorite Part of Office.1]="Outlook" || 'Table'[Favorite Part of Office.2]="Outlook" || 'Table'[Favorite Part of Office.3]="Outlook"))
Excel = COUNTROWS(FILTER('Table','Table'[Favorite Part of Office.1]="Excel" || 'Table'[Favorite Part of Office.2]="Excel" || 'Table'[Favorite Part of Office.3]="Excel"))
The results are as shown:
(3)Add a pie chart ,in the visual ,put the measures in Values .
I have attached my pbix file ,you can have a look .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TRISTANCARY
I created a sample ,maybe you can refer to it .
Original Date:
(1)Use Split Column in Query Editor , to divide a column of values into multiple columns of single values according to the separator, like this
(2)Return to desktop view ,and create measures to count the rows for each part .
Word = COUNTROWS(FILTER('Table','Table'[Favorite Part of Office.1]="Word" || 'Table'[Favorite Part of Office.2]="Word" || 'Table'[Favorite Part of Office.3]="Word"))
Outlook = COUNTROWS(FILTER('Table','Table'[Favorite Part of Office.1]="Outlook" || 'Table'[Favorite Part of Office.2]="Outlook" || 'Table'[Favorite Part of Office.3]="Outlook"))
Excel = COUNTROWS(FILTER('Table','Table'[Favorite Part of Office.1]="Excel" || 'Table'[Favorite Part of Office.2]="Excel" || 'Table'[Favorite Part of Office.3]="Excel"))
The results are as shown:
(3)Add a pie chart ,in the visual ,put the measures in Values .
I have attached my pbix file ,you can have a look .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yes, you can.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@TRISTANCARY it will make sense to split the data into rows in PQ and then everything will be easy to visualize
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
When combining values into a single graph like below:
It seems to take the values and even with the same information it keeps it as seperate precentages from their different columns. Is there a way to unify them?
If you split it into rows can you add all split rows into the same graph? I don't believe power bi let's you combine multiple rows into one graph
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |