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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Data Bug when summarizing with nulls

I've got an odd bug I believe. My data looks like this:

 

Bug 1.png
If I put that into a table with no summarizing, it looks as above.

When I put Budget/Forecast as Summarize and hours as don't summarize, I only get Budget/Forecast, Hours is blank. When I do the oposite, set Budget/Forecast as don't summarize and Hours as summarize, I get hours with blanks for Budget/Forecast. 

 Bug 2.png

Setting the nulls to 0 fixes the issue, but why is the system doing that? It is throwing data away, which feels like a bug to me. 

 

3 REPLIES 3
Greg_Deckler
Super User
Super User

Not sure I would call that a bug. It's an issue around the visuals trying to prune out unnecessary data and only focus on what is important so technically it is by design. When you are summarizing on one or the other, you are getting nulls back for that summarization. When the visuals see this, they throw out those rows because it assumes that they are worthless, no data. So, when you summarize by budget/forecast it throws out the null rows where you have hours and vice versa. It's a visualization optimization thing that just doesn't pan out in your specific circumstance.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I would agree if all values shown were null, but if I have data to display (a non-null row) it should show irregardless of if the sum column is null or not.

 

Frankly, if that's by purposeful design, it's a poor design. Not showing data is very confusing for the user (it took me a while of troubleshooting to figure out why I wasn't seeing those records as expected), and potentially dangerous from a BI perspective (missing data can lead to thinking there is no data and bad decisions). 

Hi @Anonymous,

 

You could enable the "Show items with no data" option for those unsummarized fields.

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors