Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Displaying Value without aggregation

Hi Folks, i have a column (Net price) .. i need to create a graph which shows different prices a product is sold to different customer .. e.g. bottle sold at e.g.

Red_Bottle at $10 to Cust_A in August
Red_Bottle at $12 to Cust_A in Sep
Red_Bottle at $15 to Cust_B in Aug
Red_Bottle at $11 to Cust_A in Sep

 

Now when i plot (Net Price) as a (Measure) Its getting aggregated and shows me this ...

 

Red_Bottle at $22 to Cust_A
Red_Bottle at $26 to Cust_B

 

so i duplicated this column and changed the data type to String , now it looks like this

(Red_Bottle at 2 Cust_A
Red_Bottle at 2 Cust_B) "2 is the count"

I also tried "Don't Summarize" and when i do that it gives me the count... i dont need either of them.. What i need is the exact value of "Net Price" without any aggregation or count ...
Please help...

Need Help
Show and Tell

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    Anonymous

     

    If you have multiple entries for same Customer, it must aggregate when you put Net price as a measure sliced by Customer. 

     

    In your scenario, as you already change the data type into text, you can directly put the column into visual and select the aggregation into "Last" to show the latest Price. 

     

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      v-sihou-msft i am trying to analyse price.. so in the data it is possible that a customer is sold the same product at different prices over the period of time (higher the quantity lower the price).. with what you are suggesting i will only get one price, however i would like to know each (distinct) price by customer by product.

      By the way would does powerbi identify "Last" ? is it order of the row or something else ?

       

      Also will this last option be available in all the visuals or only in some specific ones ?


      Below is what i am getting, Please see the below images..

      Raw Data in excel...

      When i changed the data type to text and used in visual it only gives the option of count and CountD... See below




      Regards

      Mohd Shariq