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 or option of achieving it?

I didnt see "Dont summarize.." for the column values display on a graph. Can u pls help?

 

Thanks,

ims

 

23 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Just wondering if you have received the solution to this. I am stuck as well. 

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

  • bjoshi's avatar
    bjoshi
    Resolver I
    9 years ago

    irfanreporting

     

    How about converting the data type of the aggregated column to text?

     

    Or,

    Selecting the column from the field list and then selecting Don't summarize from Modeling Tab.