Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Differences between the data and the visualization

Hi there,

I'm having this issue, I have a dataset that summarizes looks like this.

 

MSA_BB123_1-1650549933391.png

The thing is that when I do a visualization splitting the data between the different TEAMS in the visualization if a project appears in two different TEAM the visualization count it no matter that I select the "Distinc Count" option. In the table the problem didn't show.

 

 

 

MSA_BB123_0-1650549832789.png

 

If you see the below visualization the difference in the totals rises when the TEAM category is added in the "Legend" fiesl of the visualization.

 

MSA_BB123_3-1650550357552.png

Any Idea how to avoid this????

 

Thanks in advance.

 

1 ACCEPTED SOLUTION
AlexanderPrime
Solution Supplier
Solution Supplier

Syndicated - Outbound

You are getting a difference as the stacked column chart visual is auto hiding blanks until you add a legend to split it. 

 

As you have rows with blank information in the teams column, this is why you are getting a lower number before adding the TEAM category to that visualisation.

 

A potential workaround is to use Power Query/Transform Data to automatically replace any "Blank" value in the Team Column, to a placeholder value such as "N/A" or even a simple "-" to give it a value just so the visual has text to report. 


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

View solution in original post

1 REPLY 1
AlexanderPrime
Solution Supplier
Solution Supplier

Syndicated - Outbound

You are getting a difference as the stacked column chart visual is auto hiding blanks until you add a legend to split it. 

 

As you have rows with blank information in the teams column, this is why you are getting a lower number before adding the TEAM category to that visualisation.

 

A potential workaround is to use Power Query/Transform Data to automatically replace any "Blank" value in the Team Column, to a placeholder value such as "N/A" or even a simple "-" to give it a value just so the visual has text to report. 


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)