Forum Discussion

irfanreporting's avatar
irfanreporting
Icon for Helper I rankHelper I
9 years ago

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

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 ...
irfanreporting's avatar
irfanreporting
Icon for Helper I rankHelper I
9 years ago
Is this possible? Can you please help?
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

irfanreporting

 

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

 

Thanks

  • irfanreporting's avatar
    irfanreporting
    Icon for Helper I rankHelper I
    9 years ago

    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.

     

    DateRunTypeScenarioNodesEnqueuePerSecsDequeuePerSecsProcessedPerSecsTimeToEnqueueMs_99TimeToEnqueueMs_95TimeToDequeueMs_99TimeToDequeueMs_95
    00:00.010 Nodes110706462576129740650094
    00:00.010 Nodes2104653693691609938813219
    00:00.010 Nodes3104614614611109191721110
    00:00.010 Nodes410385345426234413441031422
    00:00.010 Nodes510369368368172109197988813
    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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's avatar
        irfanreporting
        Icon for Helper I rankHelper I
        9 years ago

        Dear Angela,

        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: