Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |