cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Data showing differently on a table visual compared to clustered bar and other visuals

Hi,

 

I am having a random issue which I am trying to find the reason to but cannot for the last 2 days. Any pointers is much appreciated. I have a direct query running in power BI which populates the table and then i have a simple measure to get the counts.

 

Count of Completed CCB CNP = CALCULATE(COUNTROWS('X'),X[FA_STATUS_FLG]="C")

 

If I just do the count of the primary key of the table without the measure, i get a count of 116 for Aug-01 week. Also, the same number shows up when i select table display.

beras_0-1628781386744.png

 

The moment i hit clusted column chart without changing anything else, with the same measure, the value changes to 73. The data label is not displayed as well for this column.

beras_1-1628781554867.png

 

I checked with other viuals, and only the  PI chart shows the value as 116 and the rest all show as 73.

 

Am i doing something incorrectly? I need to use the clustered bar for this visual and hope to use the measure instead of the count so please suggest anything i might need to do.

 

Thanks,

SB

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Anonymous Try switching your Axis to Categorical and see what that shows.


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@Anonymous Try switching your Axis to Categorical and see what that shows.


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition
Anonymous
Not applicable

You sir are very knowledgable.  That worked and I appreciate you responding to me. Have a great rest of your day!

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!