cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sthomas38
Frequent Visitor

Visual Help - Multiple Columns

Hello,

 Please could you give some ideas on how to create this visual?

I have a dataset -

ID IssueA IssueB IssueC IssueD

1       1             0            0              1

2       1             1            1              1

3       1             0            0              0

4       0             0            0              1

5       0            1             1              1

6       0            0             1              1

 

I want an easy visual to show that

IssueA  IssueB IssueC IssueD

3                  1              1              2

IssueB   IssueA IssueC IssueD

2                    1              2            2

IssueC   IssueA IssueB IssueD

2                    1              2            2

 

What I have in mind is, User picks the first Issue from a list - Example IssueA, and then three of the other issues populate in a bar chart (IssueB=1; IssueC=1;IssueD=2), then user can pick IssueB from the chart and the other three Issue are in the bar chart, if there is 0 count, then it doesn't show at all.

 

Is this possible?

2 REPLIES 2
dethompson97
Resolver III
Resolver III

What is the correlation between the two?  I am not seeing how you are deriving the bottom desired visual from the top dataset.  Can you provide a little more detail?

 

Dawn

Sure,

So if User pics IssueA, then we look at how many IDs have a 1 for IssueA - which is 3

Looking at those three only - Total count for IssueB=1; IssueC=1 and IssueD=2

 

Does that make sense? Let me know please.. Thank you.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors