Display my data values on a graph without calculated functions like sum, count etc

[irfanreporting]

Hi experts.

I want to just display my data on the graph without using count,sum,min,max.avg functions etc as in my case values are already aggregated from the datastore. Does powerBI provides a way or option of achieving it?

I didnt see "Dont summarize.." for the column values display on a graph. Can u pls help?

Thanks,

ims

[DurveshC]

Just wondering if you have received the solution to this. I am stuck as well. 

[bjoshi]

@irfanreporting

How about converting the data type of the aggregated column to text?

Or,

Selecting the column from the field list and then selecting Don't summarize from Modeling Tab.

[Vvelarde]

@irfanreporting

Hi, Create a Measure

Mymeasure=Values(Table[Column])

[irfanreporting]

Thanks a lot for your response, when I have created a measure on the column. it gives the following error.

[Vvelarde]

@irfanreporting

Are you using a table or Matrix visualization?.

In that case you need a little modification to the measure.

mymeasure=IF(HASONEVALUE(Table[Column]),VALUES(Table[Column]))

[Anshika]

Hi, I am also caught with the same situation & used the same method as you described above but I could not understand the logic behind it , why we used hasonevalue along with values in the measure.

Please explain whenever you see my post!!

Thank you!!

[irfanreporting]

Thank you for the quick response. I am using a table of "x" columns and displaying a graph for 2 columns with the same values as displayed in the table.

for ex: In my case, I have lists of ID's and for each ID have some already aggregated data i.e requests/secs from the database table so I just want to display those ID's on X-axis and individual bars with corresponding requests/secs values upon each ID bar.

[irfanreporting]

Is this possible? Can you please help?

[Vvelarde]

@irfanreporting

Sorry my late response, could you post Sample Data and the expected result.

Thanks

[irfanreporting]

Thank you for the responses and help, Please find my sample dataset below. So I just want to display the data as is on the graph with Scenarios 1,2,3,4,5 on x-axis and EnqueuePerSecs,DequeuePerSecs,ProcessedPerSecs values on Y-axis without any MIN,MAX,AVG etc.

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	4	10	385	345	426	2344	1344	1031	422
00:00.0	10 Nodes	5	10	369	368	368	172	109	19798	8813

[v-huizhn-msft]

Hi @irfanreporting,

In desktop, there is "Don't summarize" in table visual. For your requriement, you create a line or clustered cloumn chart, so it must have MIN, MAX, AVG etc aggregated functions if you want to select any number fields as value. You'd better create a measure as @Vvelarde posted, then select the measure as value.

For example, create two measure using the formulas.

DequeuePerSecs-T = IF(HASONEVALUE(Test2[DequeuePerSecs]),VALUES(Test2[DequeuePerSecs]))

EnqueuePerSecs-T = IF(HASONEVALUE(Test2[EnqueuePerSecs]),VALUES(Test2[EnqueuePerSecs]))

Then add the 'Scenario' as x-axis level, the measure as values, you will get expected result.

If you have other issues, don't hesitate to let me know.

Best Regards,

Angelia

[irfanreporting]

Dear Angela,

Based upon your response, I have created measures but seems to be displaying empty values.

Also I wanted to tell you that in my case, Scenario 1,2,3,4,5..etc can run everyday so we do have same set of scenarios on every day. So u could see duplicates record of scenarios 1,2,3,4,5 if u select multiple dates.

Thanks a lot for your response and help, For some reason I am not getting any values displayed on the graph after following all the steps. Can u pls help? Did I miss something?

Created Measure:

DequeuePerSecs-My = IF(HASONEVALUE('MyTable1'[DequeuePerSecs]),VALUES('MyTable1'[DequeuePerSecs]))

screenshot:

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

[Vvelarde]

@irfanreporting

Hi, i'm back,

please try with this:

Created Measure:

DequeuePerSecs-My = IF(HASONEVALUE('MyTable1'[Scenario]),VALUES('MyTable1'[DequeuePerSecs]))

[Banan]

This solution does not work if I want to use a “clustered bar chart” and I want to put a new measure in the x-axis. What is the solution?

[irfanreporting]

Thank you Victor, but I got the error as shown.

[irfanreporting]

Also when I present the same values on the table instead of graph then I m seeing empty values for the measure.

If you see in the screenshot, I am seeing actual values for DequeuePersecs but for created measure "DequeuePerSecs-My" measure shows empty values.

[Vvelarde]

@irfanreporting

Just for testing what happen if you add date to the table.

[irfanreporting]

I got some values in this case.

[Sean]

What is the expected output based on the sample data on this 2nd page?

I don't see how else you can diplsay data for each Scenario that has multiple values WITHOUT aggregating?

And as you can see you don't really need any Measures to do this - just drag both columns.

[irfanreporting]

Thankyou for the response, Are you calculating the "TheDate" measure in the above resolution? Please find my sample dataset attached. I couldnt able to display dates with the corresponding values. In my case, Date is the unique field where I ran duplicated scenarios.What would be the best way I can display the data on the graph to show each scenario with the corresponding Enqueue/secs,Dequeue/secs without using sum,min.max functions. Just wanted to use the same data as is in the table for displaying on a graph. Whenever I drag in any of the above fields it is showing only min.max,count,avg as the options in the menu

Scenario	EnqueuePerSecs	DequeuePerSecs	TimeToEnqueueMs_95	TimeToEnqueueMs_99	TimeToDequeueMs_95	TimeToDequeueMs_99	Date
1	16	3	78	153.95	281	344	4/2/2017 0:00
1	30	7	16	31	47	47	4/2/2017 0:00
2	3	3	109	172	172	251	4/2/2017 0:00
3	5	5	63	63	78	78	4/3/2017 0:00
1	7	7	63	78	78	94	4/2/2017 0:00
1	21	3	78	156	234	281	4/2/2017 0:00
3	28	6	16	31	47	63	4/3/2017 0:00
4	28	6	16	31	47	63	4/8/2017 0:00
1	29	6	16	31	47	47	4/6/2017 0:00
1	29	6	16	31	47	47	4/7/2017 0:00
5	29	6	16	31	47	63	4/2/2017 0:00
6	3	3	109	188	172	281	4/2/2017 0:00
1	6	6	63	63	78	78	4/8/2017 0:00
1	6	6	63	63	78	79	4/6/2017 0:00
5	6	6	63	78	78	94	4/2/2017 0:00
6	6	6	63	78	78	94	4/7/2017 0:00
1	6	6	78	78	94	94	4/3/2017 0:00
1	400	115	47	63	31	63	4/8/2017 0:00
1	115	115	78	94	94	109	4/8/2017 0:00
10	0	0	1181.4	3570.48	2021.24	8617.72	4/2/2017 0:00
10	0	0	1669.4	4054	2254.84	3924.36	4/3/2017 0:00
10	838	266	63	109	47	78	4/6/2017 0:00
10	842	269	63	109	31	78	4/7/2017 0:00
10	0	0	78	109	219	281	4/3/2017 0:00
10	0	0	78	113.16	156	250	4/2/2017 0:00
10	237	237	78	125	125	203	4/7/2017 0:00
10	292	292	78	125	109	203	4/6/2017 0:00
10	405	228	47	94	47	125	4/9/2017 0:00
10	228	228	94	141	125	266	4/9/2017 0:00