Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
MalvikaBhasin
Helper III
Helper III

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 get desired visual? 

 

Basedata.JPGBase data2.JPG

 

Regards

Malvika

3 REPLIES 3
ibarrau
Super User
Super User

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,


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

Happy to help!

LaDataWeb Blog

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

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,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Fabric Data Days is here Carousel

Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.