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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sandeshp
Frequent Visitor

Data in Table visual does not match with bar chart

I have a table visual which has two columns(CITY and STUDENT_ID):

sandeshp_0-1711866602303.png

This data is correct. But when I convert the same table to a column chart, only one column is shown. 

sandeshp_1-1711866746966.png

Why is this happening and how do I fix this?
Please check out the attached PowerBI file.

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @sandeshp ,

 

Thanks for the reply from @PhilipTreacy , please allow me to provide another insight: 

In Power BI Desktop, if the data you put into Visual is the same, then the data is automatically aggregated.

vyangliumsft_0-1712037435624.png

So you need to put [Account ID] into Visual to form each individual line.

vyangliumsft_1-1712037435634.png

 

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.

View solution in original post

6 REPLIES 6
v-yangliu-msft
Community Support
Community Support

Hi  @sandeshp ,

 

Thanks for the reply from @PhilipTreacy , please allow me to provide another insight: 

In Power BI Desktop, if the data you put into Visual is the same, then the data is automatically aggregated.

vyangliumsft_0-1712037435624.png

So you need to put [Account ID] into Visual to form each individual line.

vyangliumsft_1-1712037435634.png

 

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.

Thanks @v-yangliu-msft , this approach shows the correct data in the column chart.

Is there any way to make the color of all columns same? 

Furthermore, how would this work if I were to add a different field as the legend?

PhilipTreacy
Super User
Super User

@sandeshp 

 

In the file you linked, it opens with a column chart.  If you change the visual from column to table, there is still only 1 city shown, Chicago.  That's due to the visual level filter.

 

In the image you initially posted, that filter can't have been applied to the table.

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


@PhilipTreacy Let me add the steps I am following:
1. This is the column chart in my attached file:

sandeshp_0-1711884096107.png

2. Convert the column chart to table:

sandeshp_1-1711884152775.png

3. Change the column "Count of Student ID" to "Dont summarize":

sandeshp_2-1711884233836.png

4. This now displays 2 rows, Chicago and Orlando.

sandeshp_3-1711884281234.png

Ideally, I want these two cities (Chicago and Orlando) in the column chart, with "Count of student ID" as 1 for each of them.
Please let me know if I'm missing something.

PhilipTreacy
Super User
Super User

Hi @sandeshp 

 

You've got a visial level filter on the Column Chart to only display data when the measure [CurrentStudentsOnly] is 1.  That will only display Chicago.

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


@PhilipTreacy Yes, I have the filter [CurrentStudentsOnly] = 1. The same filter is applied on both, the table visual as well as the column chart as well.

I am just changing the visual type from table visual to column chart, moving the student ID to y axis, so that it takes in the "count of student ID"
The column chart should have shown two bars, right?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.