Forum Discussion

michaeljc70's avatar
michaeljc70
Advocate II
10 years ago

Make a column not sum/count

I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations.  I am still fairly new to this though and cannot figure this out.    I imported a ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi all, 

I have a similar problem. 

I imported 2 datasets, fixed the relationships and made sure the fields I need are formated as decimals. 

In 1st dataset I have project name and Metric1 and in the 2nd project name and Metric2. 

I want to create a scatter plot with the 2 metrics. When I try this, X Axis (metric 1) works pretty good and adjusts the position of the point according to the metric value. For metric2 though, no matter what I choose from the value drop down menu, gives me the total average/sum/count of all metric2. I choose Dont summarize but still no fix. 

 

Can you help?

Thanks 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Can you upload a screen shot of your headers and maybe row 1 of your dataset?