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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
vdburg
Resolver I
Resolver I

Error with visual objects with too many values

Hi,

When there are too many values in an visual object it just randomly filters out some channels and shows a total different thing than what it is suppossed to.

 

I have made up a table with 999 channels, with some random values. When I just select 52 of those values it works ok:

Screenshot_Too_Many_Values_OK.JPG

 

But when I just leave all of them, the chart just removes some values and shows different proportions:

Screenshot_Too_Many_Values_Wrong.JPG

 

It shows a small icon warning that it has too many values. I have tried to make clear to every user that when this happens they should be careful. But they don´t see it and it leads to many misinterpretations of the data. And although I could teach everyone to be careful the Power BI team should come up with a different solution. The chart doesn´t have to show all the channels, but it should show in descending order those with the highest upon to the lowest values, but still calculate the proportion over all values.

 

I consider this an urgent issue to address. It doesn´t make sense to offer a tool with many amazing features but that in some cases causes misinterpretations of the data, which can lead to organizations to make wrong decisions.

 

I just found out that I posted the same issue almost two years ago. I am amazed by Power BI as a tool and excited about every new feature the Power BI team launches every month but it dissapoints me very much that this issue hasn´t been addressed.

3 REPLIES 3
amitchandak
Super User
Super User

@vdburg , just check if there is an option for data volume. Else create rank for the legend and filter it by say top 100.

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak ,

thanks for your workaorund suggestion. Unfortunately I can´t apply it because I have a live connection to a SSAS multidimensonal cube, so I can´t apply DAX functions to it. There might be other workarounds, but I think the Power BI team should have a look at it, as I don´t consider that solving it should be such a big issue.

@vdburg , Check if there an idea already vote for that. else create new

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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