Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |