Forum Discussion

irfanreporting's avatar
irfanreporting
Helper 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 ...
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

irfanreporting

 

Hi, Create a Measure

 

Mymeasure=Values(Table[Column])

  • irfanreporting's avatar
    irfanreporting
    Helper I
    9 years ago

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

     

     

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      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]))

      • irfanreporting's avatar
        irfanreporting
        Helper I
        9 years ago

        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.