Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Visual Help - Multiple Columns


 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?

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?




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

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 on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors