Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
robasp
Regular Visitor

Line chart showing individual lines from individual results within the same groupId

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:
       

BatchIdResultIdPlateGroupIdResult
BatchA1082
BatchA2082
BatchA3186
BatchA4186
BatchA5288
BatchA6282
BatchA7386
BatchA8374
BatchA9490
BatchA10488
BatchA11580
BatchA12584
BatchB13092
BatchB14090
BatchB15190
BatchB16194
BatchB17286
BatchB18288
BatchB19392
BatchB20380
BatchB21484
BatchB22488
BatchB23576
BatchB24572
BatchC25082
BatchC26082
BatchC27086
BatchC28186
BatchC29188
BatchC30182
BatchC31286
BatchC32274
BatchC33290
BatchC34388
BatchC35380
BatchC36384
BatchC37482
BatchC38482
BatchC39486
BatchC40586
BatchC41588
BatchC42582

 

And I would like to be able to visualize it something like this (dont mind the lables):

 

robasp_0-1683797532520.png

 

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

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @robasp ,

Please check the model and the format setting.

vcgaomsft_0-1684914104678.png

 

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

View solution in original post

1 REPLY 1
v-cgao-msft
Community Support
Community Support

Hi @robasp ,

Please check the model and the format setting.

vcgaomsft_0-1684914104678.png

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors