Grouping Data

[drallam]

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?

[chotu27]

@drallam  Go to Query ediotor and do Group by column A then you will get the count  please check below image

[chotu27]

@drallamJust be clear do you want the count of column B in card by selecting list containg column A ??

[drallam]

I want the actual description.

[Eric_Zhang · Accepted solution]

@drallam

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.