Forum Discussion

jmiridium's avatar
jmiridium
Helper IV
9 years ago

Count Issue

I am importing data from an Excel spreadsheet or a CSV file to use or charting, the values always automatically count. I don't want this behavior. How do I prevent this?
Need Help
jmiridium's avatar
jmiridium
Helper IV
9 years ago

I want it to not count time. Each time is a specific time frame

 

jmiridium's avatar
jmiridium
Helper IV
9 years ago

Don't count it, don't sum it. don't count distinct. Just plot the data in the same manner as Excel

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Gotcha.  In general, values are always aggregated in some way, cuz there will be a set of rows that match that point on the Axis.  Since in your case, you know there is just 1 value... you could just use SUM( ) or AVERAGE( ) or MIN( ) or MAX( ) ... and all would return the same value, no?

    • jmiridium's avatar
      jmiridium
      Helper IV
      9 years ago

      This is a bad behavior. I should be able to just have the numbers import in the same manner as the excel spreadsheet. If not, this makes PowerBI an ineffective tool to use

      • jmiridium's avatar
        jmiridium
        Helper IV
        9 years ago

        The data in both Excel and the Data view in PowerBI shows the data correctly. It's when I try to graph it, it always counts. If I add a Table and place the data in the table, it shows up incorrectly: