Forum Discussion

andrewhoddie's avatar
andrewhoddie
Regular Visitor
9 years ago
Solved

stop aggregation on visualisations

Hi   I am new to Power BI Desktop.  I have imported a simple dataset which has a KPI description, a target figure and the current value.  On the dataset under modelling i have set each column to no...
  • andrewhoddie's avatar
    andrewhoddie
    9 years ago

    Hi

     

    Thanks for the reply. 

     

    I think I have worked out aggregates, i think the major issue was the data coming through as Text which then caused me only to allow count options

     

    thanks

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi andrewhoddie

 

for some visuals, if you don't want it aggregated, put it in the AXIS or LEGEND fields if they are available.  If you drag it to VALUES, the visual may try to aggregate it for you.