Select a single or multiple records in a table and display it on graph with no calculations

[irfanreporting]

Hi,

I want to select a single or multiple records in a table and display it on graph with no calculations, Is this achievable in power BI?

Thanks,

Irfan

[ibarrau]

Hi. Can you explain a bit more about what are you trying to do? When i read this i think you are asking to have individual values in table. After adding them to visual, check a little arrow that let's you choose an agregation or "not summarize".

If what you need si not that, maybe you are looking for the new matrix that allows you to click on values to filter.

Hope we make an understanding so i can help more.

Regards,

[irfanreporting]

Sorry for the confusion, I have a sample data in the table and if I select on any row record in the table then it should display some of the columns values which I wanted to show on the graph for that selected row record.

If I select first row (scenario 1) in the table then corrresponding EnqueuePerSecs (706),DequeuePerSecs(576),ProcessedPerSecs (576) should display on a  graph as is.

Date	RunType	Scenario	Nodes	EnqueuePerSecs	DequeuePerSecs	ProcessedPerSecs	TimeToEnqueueMs_99	TimeToEnqueueMs_95	TimeToDequeueMs_99	TimeToDequeueMs_95
00:00.0	10 Nodes	1	10	706	462	576	1297	406	500	94
00:00.0	10 Nodes	2	10	465	369	369	1609	938	813	219
00:00.0	10 Nodes	3	10	461	461	461	110	91	9172	1110
00:00.0	10 Nodes	2	10	385	345	426	2344	1344	1031	422
00:00.0	10 Nodes	1	10	369	368	368	172	109	19798

[ibarrau · Accepted solution]

Ok. You should enable the new matrix preview feature. This pivot table allows you to filter the page by the row/column/cell you click. Then create the chart you want to visualize when click on the rows.

Let me know if you have any luck!