Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |