Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Regards
Malvika
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,
Happy to help!
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,
Happy to help!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 32 | |
| 18 | |
| 14 |