Forum Discussion

Bhawana_Sharma's avatar
Bhawana_Sharma
Regular Visitor
3 years ago
Solved

How to remove COUNT from Y axis?

So I have been following this youtube video. And I have also followed this youtube video. But with both the datasets I am running into an issue with Y-axis, I don't know what I am doing wrong as I ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Bhawana_Sharma 

    Thanks for your quick reponse!

    This is the video screenshot, you can see the value is 0-400. This is just the sum of the [Price].

    We can see the data in a table visual to test :

    So actually this video is actually the sum of the [Price]. And the name of this field we can just double click to replace to anything you want :

     

    We don’t need to pay too much attention to the field names next to it, what we need to pay attention to is the data itself and the display of the data.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hello Bhawana_Sharma  Can you share your demo data set in-order to get a better understanding.
Thanks you.

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , Bhawana_Sharma 

    According to your description, you want to make the [Price] summarization to "SUM" instead of the "Count".

    I test it in my side , it work good. As in your screenshot , i see that the [Price] field seems to be a "Text" type field .

    That's why it can't sum, only numbers and decimals can use SUM.

     

    So , you can try to check the field type in Power BI Desktop first:

     

    If this method does not meet your needs, you can provide us with your special sample pbix file, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • Bhawana_Sharma's avatar
      Bhawana_Sharma
      Regular Visitor
      3 years ago

      Hi v-yueyunzh-msft , 

      Thanks for replying but I don't want the Price to be summed up..

      I don't want the data to be aggregated at all.

      This is how I want it to be

      Screenshot from the YouTube video I was trying to follow

       

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi , Bhawana_Sharma 

        Thanks for your quick reponse!

        This is the video screenshot, you can see the value is 0-400. This is just the sum of the [Price].

        We can see the data in a table visual to test :

        So actually this video is actually the sum of the [Price]. And the name of this field we can just double click to replace to anything you want :

         

        We don’t need to pay too much attention to the field names next to it, what we need to pay attention to is the data itself and the display of the data.

         

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly