Forum Discussion
Helper IDisplay my data values on a graph without calculated functions like sum, count etc
Community Champion
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]))
Helper IThank 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.
- irfanreportingIs this possible? Can you please help?
- Vvelarde
- 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