Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi
Im having trouble showing my data the way I want to in a line chart in Power Bi and would like som help trying to figure out how to do this.
My data looks like this:
BatchId | ResultId | PlateGroupId | Result |
BatchA | 1 | 0 | 82 |
BatchA | 2 | 0 | 82 |
BatchA | 3 | 1 | 86 |
BatchA | 4 | 1 | 86 |
BatchA | 5 | 2 | 88 |
BatchA | 6 | 2 | 82 |
BatchA | 7 | 3 | 86 |
BatchA | 8 | 3 | 74 |
BatchA | 9 | 4 | 90 |
BatchA | 10 | 4 | 88 |
BatchA | 11 | 5 | 80 |
BatchA | 12 | 5 | 84 |
BatchB | 13 | 0 | 92 |
BatchB | 14 | 0 | 90 |
BatchB | 15 | 1 | 90 |
BatchB | 16 | 1 | 94 |
BatchB | 17 | 2 | 86 |
BatchB | 18 | 2 | 88 |
BatchB | 19 | 3 | 92 |
BatchB | 20 | 3 | 80 |
BatchB | 21 | 4 | 84 |
BatchB | 22 | 4 | 88 |
BatchB | 23 | 5 | 76 |
BatchB | 24 | 5 | 72 |
BatchC | 25 | 0 | 82 |
BatchC | 26 | 0 | 82 |
BatchC | 27 | 0 | 86 |
BatchC | 28 | 1 | 86 |
BatchC | 29 | 1 | 88 |
BatchC | 30 | 1 | 82 |
BatchC | 31 | 2 | 86 |
BatchC | 32 | 2 | 74 |
BatchC | 33 | 2 | 90 |
BatchC | 34 | 3 | 88 |
BatchC | 35 | 3 | 80 |
BatchC | 36 | 3 | 84 |
BatchC | 37 | 4 | 82 |
BatchC | 38 | 4 | 82 |
BatchC | 39 | 4 | 86 |
BatchC | 40 | 5 | 86 |
BatchC | 41 | 5 | 88 |
BatchC | 42 | 5 | 82 |
And I would like to be able to visualize it something like this (dont mind the lables):
For each "PlateGroup" There are two (sometimes more) replicates and I want to show them under the same "PlateGroup" togheter with the mean result. Meaning the x-axis should be "PlateGroup" and the y-axis should be result. But I dont know how to show the individual result values (from the different "ResultId") under the same "PlateGroup" without them being summarized or calculated somehow.
At the same time I would like to filter/slize the line chart based on the BatchId. As I have it now in my report, I only show the mean values with the BatchId as the legend. So if I have a slicer for BatchId and slice it between the different BatchId´s I see the mean line in the line chart only and I see the line connected to the BatchId chosen in the slicer.
Hope anyone out there can help me with this, I´ve been thinking too long on this now so my brain is fried and cant think out of the box anymore 🙂
Kind regards
Robert
Solved! Go to Solution.
Hi @robasp ,
Please check the model and the format setting.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @robasp ,
Please check the model and the format setting.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |