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 Augu...
Need Help
Show and Tell
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