cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Legend of stacked column is not showing all values

Hi,

 

I am using a stacked column with a legend. I can drill down Year and Week. When the column is showing the year data than I see all values in the legend, but when I drill down to week than not all values are showing in the legend. When I choose the option "show as table" than the missing values are showing.

 

Kind regards,

B. Yener

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi @BYENER ,

 

Please report this as an Issue using issues.powerbi.com.  first check to see if it has already been reported.  

 

Best Regards,

Dedmon Dai

View solution in original post

13 REPLIES 13
Highlighted
Super User IV
Super User IV

@BYENER , sample screenshot. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted

Hi @amitchandak 

 

How can I add the attachement to this message?

Highlighted

@BYENER , for Image you have an option in the bar above the text area. For data, either copy-paste from excel to here. Or upload at one driver or dropbox and share a link



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted

@amitchandak  Thank you! 

 

Data and PBIX Report 

 

Highlighted

@BYENER , what do you think is missing when you drill ?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted

MFB is missing while we have a lot of MFB in the dataset

Highlighted

There are too many legend values for the visual to hande:

image.png

/ J


Connect on LinkedIn
Highlighted

Yes, I saw it, but is there a way to fix that?

Highlighted

Hi @BYENER ,

 

The limit is the number of distinct axis labels displayed. Once so much is displayed in this visualization, It becomes very unreadable.

 

I am not aware of any way to superscede the default limits of certain visualizations. You may need to filter data not to show all values.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors