Forum Discussion
stacked and clustered column (basics)
Hi Anonymous ,
As you refer in Power BI when the values are too smal they aren't visible, you can make a custom formatting for each of the lines and column data lables, just turn on the customize series, however small values are not visible, a possible workaround is to:
- Turn off data labels
- Create 6 cards and make use of filters to choose the Sales or Number of Ref and each of the 3 measures
- Format the cards without any background and small size letter
- Place it on top of the bars
Inconvinient on this is that if the size of the bars changes the values will remain on the same place so probably you will get value away from the bars.
Another way is to create a table and place it on bottom of the chart.
MFelix, very thankful for all your support on my initial steps with Power Bi.
I finally achieved to obtain the graph i need as per your example.
as a final question for Power BI experts like you is how to show the small percentages on the Data Labels that I will always have for Top 30 or Rest A ? they are not visible on the sheet anymore. I read there is no solution for that in Power BI? (as not possible to choose "outside end" )
In Excel I could show them Outside and even play with the font side of each one...
If the reports are going to be revised by management not showing any value is a no-go....
thanks again... & again 🙂
Super UserHi Anonymous ,
As you refer in Power BI when the values are too smal they aren't visible, you can make a custom formatting for each of the lines and column data lables, just turn on the customize series, however small values are not visible, a possible workaround is to:
- Turn off data labels
- Create 6 cards and make use of filters to choose the Sales or Number of Ref and each of the 3 measures
- Format the cards without any background and small size letter
- Place it on top of the bars
Inconvinient on this is that if the size of the bars changes the values will remain on the same place so probably you will get value away from the bars.
Another way is to create a table and place it on bottom of the chart.
- MFelix
Hi Anonymous ,
Don't forget to mark the correct answer for the post in order to help others.