Tables are showing, but graphs and other visualizations are blank or looking weird

[Anonymous]

When i put a table on PowerBi, everything looks normal, but when i want to visualize the data, it turns out blank. Or if i put the columns into 'Value', it ends up looking weird.

I am just trying to compare various data across different years. Why is it so hard? Any help please?

@vanessafvg @v-jiascu-msft @v-qiuyu-msft @Hardik @amitchandak @parry2k @selimovd @jamesdales @Anonymous @v-kelly-msft @v-deddai1-msft 

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

I created some data:

You have blank data above, because you put the [EQUITES] field on Legend, resulting in no data in Value.

1. Display the value (sum, count, etc.) on the Y axis and group by data on the X axis

2. Legend represents that we can use different colors and different categories to represent our bar graph

If you want to display the annual EQUITES for comparison, you can place the Year field in Axis for grouping, and place [EQUITES] in Value for value.

Legend uses different colors to distinguish categories. For example, if we place the group field in Legend, at this time, it will group according to the group field and display different colors without affecting the grouping by Year.

For more functions of the stacked column chart, you can view it in the following link:

https://www.c-sharpcorner.com/article/introduction-to-power-bi-visuals-part-2-stacked-column-chart/

https://www.tutorialgateway.org/power-bi-stacked-bar-chart/

Best Regards,

Liu Yang

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

[selimovd]

Hey @Anonymous ,

looks like the column "EQUITIES" is formatted as text and not as a number. So it just counts the amount of rows what is 1 for every year.

Change the format to decimal number and it should work.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

If i change the format to decimal, do i have to leave the "summation" option on? Because nothing is really changing.