Forum Discussion

MalvikaBhasin's avatar
MalvikaBhasin
Helper III
2 years ago

Table Presentation

Hi, In table below is my base data, just two columns.  However, it is not getting presented in an appropriate manner in Power BI.    Can you guide on how can it be presented in right manner to ge...
Need Help
ibarrau's avatar
ibarrau
Super User
2 years ago

Hi. It looks like you are picking the chart that shoes percentages of values by legend. You can change the chart if you first click on it, then on the small window opened next to the chart check "suggestions". There is a down arrow icon that will open all visuals, pick the table (not matrix).

I hope that helps,

  • MalvikaBhasin's avatar
    MalvikaBhasin
    Helper III
    2 years ago

    Hi Ibarrau,

     

    This is not about what suggestion gets selected, its about data on x-axis and y-axis seems to be picked up incorrectly. Need to know how that can be corrected? 

     

    Regards

    Malvika

    • ibarrau's avatar
      ibarrau
      Super User
      2 years ago

      I see. If you check the Y-Axis you will see you are counting revenue instead of summing. If you count the rows of the column all values would be the same. That's why all bars are the same. Make sure your Revenue column is a type number at Power Query so you can change that or create a measure that SUM(Table[Revenue]).

      I hope that helps,