Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@BYENER , sample screenshot. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@BYENER , what do you think is missing when you drill ?
MFB is missing while we have a lot of MFB in the dataset
There are too many legend values for the visual to hande:
/ J
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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |