Forum Discussion

drallam's avatar
drallam
Helper II
9 years ago
Solved

Grouping Data

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). 

1A
1B
1C
1F
1G
1H
1T
2A
2B
2C
2D
3G
3H
3T
3A
3B

How do i do that?

  • 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.

4 Replies

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

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee

        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.

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