N is to N relationship Data Shaping

[rds_2019]

Hi All,

My Data is in below shape. I am trying to figure out a way, where I can report showing how may Points each "Detail" (from 1 to 17) has got as "TRUE" in chart  format

So any ideas how can this be achieved by change in data and how to show in which chart?

Regards,

RDS

Points

Detail 1

Detail 2

Detail 3

Detail 4

.

.

.

.

.

Detail 15

Detail 16

Detail 17

a1

TRUE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

a2

FALSE

FALSE

TRUE

TRUE

TRUE

FALSE

TRUE

a3

TRUE

TRUE

FALSE

FALSE

TRUE

FALSE

TRUE

a4

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

a5

FALSE

TRUE

TRUE

TRUE

FALSE

TRUE

FALSE

a6

FALSE

TRUE

FALSE

TRUE

FALSE

TRUE

TRUE

a7

TRUE

FALSE

TRUE

FALSE

FALSE

FALSE

a8

TRUE

FALSE

TRUE

FALSE

FALSE

FALSE

a9

TRUE

TRUE

TRUE

FALSE

FALSE

a10

TRUE

TRUE

TRUE

.

TRUE

.

TRUE

TRUE

.

TRUE

.

TRUE

TRUE

.

.

.

.

.

a100

TRUE

FALSE

FALSE

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

[Anonymous · Accepted solution]

Hi,  you can try by using unpivot in power query:

And then add attribute as axis and count of value as value in a columnchart with value filter equals True: 

[rds_2019]

Thanks you for replying. It does work out well