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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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