Forum Discussion

PatrickCote's avatar
PatrickCote
New Member
9 years ago

Data with no sum

Hi everybody, I'm  trying to build a chart with values ​​without any sum, only the raw values. I tried to change the sum default value to "no sum" but it does not work, a calculation is still mandat...
Need Help
PatrickCote's avatar
PatrickCote
New Member
9 years ago

Ya sure!

Explaination: I have values that identified the performace of a system hourly. I just want to represent the performance of the system hour by hour for a specific day. That's why I dont want sum! Here's the pics (sorry french screenshot).

Here's a view of the data:

 

What I try to not summarize:

 

 

The result:

Thanks

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

So, you should be able to put that into something like a line chart or column chart with Date and Heure in your axis and TO_NUMBER... as a value and then it shouldn't matter that you are doing a sum?

  • PatrickCote's avatar
    PatrickCote
    New Member
    9 years ago

    That's the problem....I don't have to option to not summarize...

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Drill down into your data with the down arrow icon.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        9 years ago

    • fhill's avatar
      fhill
      Icon for Resident Rockstar rankResident Rockstar
      9 years ago

      Change your data type to a 'Decimal Number'   ( ??? Nombre décimal ???) in your Query Editor...   I think your data is TEXT now, and the only want Power BI can 'summarize' Text data is to count it as values...

       

      FOrrest