The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm wondering how to group data based on two columns. I want to create flashcards and when we click the the list (ColumnA) it should show all the data pertaining to that value from (ColumnB).
1 | A |
1 | B |
1 | C |
1 | F |
1 | G |
1 | H |
1 | T |
2 | A |
2 | B |
2 | C |
2 | D |
3 | G |
3 | H |
3 | T |
3 | A |
3 | B |
How do i do that?
Solved! Go to Solution.
I think you can use a slicer visual, a multiple-row visual and a card visual to achieve your goal. See the demo in the attached pbix file.
@drallam Go to Query ediotor and do Group by column A then you will get the count please check below image
@drallamJust be clear do you want the count of column B in card by selecting list containg column A ??
I want the actual description.
I think you can use a slicer visual, a multiple-row visual and a card visual to achieve your goal. See the demo in the attached pbix file.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
108 | |
69 | |
46 | |
43 |
User | Count |
---|---|
188 | |
87 | |
77 | |
74 | |
60 |