We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.