Forum Discussion
Display my data values on a graph without calculated functions like sum, count etc
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 |
Hi, i'm back,
please try with this:
Created Measure:
DequeuePerSecs-My = IF(HASONEVALUE('MyTable1'[Scenario]),VALUES('MyTable1'[DequeuePerSecs]))
Thank you Victor, but I got the error as shown.
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.
I got some values in this case.
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.
I couldnt able to display multiple scenarios as you are displaying, Did I miss out anything?
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 Hi irfanreporting,
Besides table visual, there is no "Don't summarize" option. Otherwise, you need to create a measure, but the measure posted is not useful?
Best Regards,
AngeliaThis 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?
