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.
I am trying to make a 2 box plot graphs and use some filters on that:
The data looks like this:
ID | Result | Result-Value |
1 | Negative | 37 |
1 | Inconclusive | 34 |
1 | Positive | 9 |
1 | Suspect | 26 |
1 | Positive | 23 |
2 | Positive | 26 |
2 | Positive | 13 |
2 | Negative | 40 |
2 | Negative | 37 |
3 | Negative | 40 |
3 | Suspect | 35 |
3 | Negative | 37 |
4 | Positive | 22 |
4 | Positive | 21 |
4 | Positive | 16 |
5 | Negative | 37 |
5 | Negative | 37 |
5 | Negative | 37 |
5 | Suspect | 35 |
5 | Negative | 37 |
5 | Negative | 37 |
The graphs that I am trying to build are:
1-Box-plot for all different results;
2-Box-plot for all the results but considering that in each ID only can count on time and the criteria for the count is negative > suspect> inconclusive > positive. Where only will cont once per ID.
Any idea how can I build then?
Hi @Giovani,
Are you talking about custom visual 'Box and Whisker chart'?
To show all different results in this visual, you only need to drag [ID] to Category section, [Result] into Sampling section and drag [Result-Value] into Values section.
I cannot understand what you said that 'considering that in each ID only can count on time and the criteria for the count is negative > suspect> inconclusive > positive'. How to calculate the count for each ID? Could you provide more description about your requirement? It would be better you can post an image to show us your desired output.
Best regards,
Yuliana Gu
Hi Yuliana,
Yes, I am talking about 'Box and Whisker chart'.
I tried to follow your steps but didn`t get the results.
I am going to update my database including another column with the date.
ID | Result | Result-Value | Date |
1 | Negative | 37 | 1/1/17 |
1 | Inconclusive | 34 | 1/1/17 |
1 | Positive | 9 | 1/1/17 |
1 | Suspect | 26 | 1/1/17 |
1 | Positive | 23 | 1/1/17 |
2 | Positive | 26 | 2/2/17 |
2 | Positive | 13 | 2/2/17 |
2 | Negative | 40 | 2/2/17 |
2 | Negative | 37 | 2/2/17 |
3 | Negative | 40 | 4/2/17 |
3 | Suspect | 35 | 4/2/17 |
3 | Negative | 37 | 4/2/17 |
4 | Positive | 22 | 4/3/17 |
4 | Positive | 21 | 4/3/17 |
4 | Positive | 16 | 4/3/17 |
5 | Negative | 37 | 6/17/17 |
5 | Negative | 37 | 6/17/17 |
5 | Negative | 37 | 6/17/17 |
5 | Suspect | 35 | 6/17/17 |
5 | Negative | 37 | 6/17/17 |
For the first steps, I am looking to build a 'Box and Whisker chart' only with positive results in y-axis. I don`t want to compute together the results that are negative, suspect and or inconclusive.
In the x-axis, I am looking to insert a timeline with each month of the year to compare the results year around.
Please, let me know if now it is more clear the result that I am looking for.
Thanks.
Hi @Giovani,
First, create a Month column in source table.
Month = Sheet1[Date].[Month]
To show all results in chart visual, please see below image.
If you only want to display positive results, you can set a visual level filter like below:
Best regards,
Yuliana Gu
I am trying to make a 2 box plot graphs and use some filters on that:
The data looks like this:
ID | Result | Result-Value |
1 | Negative | 37 |
1 | Inconclusive | 34 |
1 | Positive | 9 |
1 | Suspect | 26 |
1 | Positive | 23 |
2 | Positive | 26 |
2 | Positive | 13 |
2 | Negative | 40 |
2 | Negative | 37 |
3 | Negative | 40 |
3 | Suspect | 35 |
3 | Negative | 37 |
4 | Positive | 22 |
4 | Positive | 21 |
4 | Positive | 16 |
5 | Negative | 37 |
5 | Negative | 37 |
5 | Negative | 37 |
5 | Suspect | 35 |
5 | Negative | 37 |
5 | Negative | 37 |
The graphs that I am trying to build are:
1-Box-plot for all different results;
2-Box-plot for all the results but considering that in each ID only can count on time and the criteria for the count is negative > suspect> inconclusive > positive. Where only will cont once per ID.
Any idea how can I build then?
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |