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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BYENER
Helper V
Helper V

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

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
amitchandak
Super User
Super User

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

@amitchandak  Thank you! 

 

Data and PBIX Report 

 

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

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

tex628
Community Champion
Community Champion

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

image.png

/ J


Connect on LinkedIn

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

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

Hi @v-deddai1-msft 

 

Thank your for your reply, but I have to show all values. The strange thing is that the value is visible when the chart shows the year value and not when I drill down to week while a year has more values in the legend.

 

Thanks for the help!

 

Kind regards,

B. Yener

Hi @BYENER ,

 

Have you ever check show item with no data option in legend?

 

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

Yes I did, but still the same issue. Nothing to do I have to deal with it.

 

Thanks for the support.

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

Hi @amitchandak 

 

How can I add the attachement to this message?

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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