Forum Discussion
Helper IDisplay my data values on a graph without calculated functions like sum, count etc
Microsoft EmployeeHi 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
Helper IDear 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
Community Champion
Hi, i'm back,
please try with this:
Created Measure:
DequeuePerSecs-My = IF(HASONEVALUE('MyTable1'[Scenario]),VALUES('MyTable1'[DequeuePerSecs]))
- 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
I got some values in this case.
SeanWhat 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
I couldnt able to display multiple scenarios as you are displaying, Did I miss out anything?
- 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 - v-huizhn-msft
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,
Angelia 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?
