Forum Discussion
BAR Chart values not showing
Hi All,
I want to show number and Percentage in my bar chart. In below Bar chart you can see we have 2 category one is 0-7 and >7 days which is in red colour number is visible only for consumer which is 80 80 and 9.12 % In same way I want to show number and % for other segment as well like : Commercial ,MFI and OLM , Is there any way we can show this.
Hi Sandeep13 ,
The only option I see now is to stack the charts.
Below create a 100% stacked bar chart, disable the data label for >7 Days. Create a Line Chart that shows the Share values, invert the Y-axis so that 0% starts at the top. Disable everything possible (titles, values, background) and stack one on top of the other.
You can also disable interactions between them, and also group the two visualizations and enable maintain layer order so that no one changes the visualization order.Memorable Member | Former Super User
If I helped, please accept the solution and give kudos!
LinkedinHi lkalawski ,thanks for the quick reply, I'll add more.
Hi Sandeep13 ,
When I finished my testing, I found that the problem was solved, but I still wanted to share my solution.
1.Disabled data labels older than 7 days
2.Create a line chart and create the following measures
Measure1 = CALCULATE(SUM('Table'[Count of Member_File_Name]),'Table'[LOAD_TAT_Category] = ">7 Days")Measure2 = VAR _result = CALCULATE(SUM('Table'[Count of Member_File_Name]),'Table'[LOAD_TAT_Category] = ">7 Days") RETURN _result & UNICHAR(10) & FORMAT(DIVIDE(_result,SUM('Table'[Count of Member_File_Name])),"0.00%")3.Adjust the position of the line chart and place it at the top.
Best Regards,
Wenbin Zhou
6 Replies
Hi lkalawski ,thanks for the quick reply, I'll add more.
Hi Sandeep13 ,
When I finished my testing, I found that the problem was solved, but I still wanted to share my solution.
1.Disabled data labels older than 7 days
2.Create a line chart and create the following measures
Measure1 = CALCULATE(SUM('Table'[Count of Member_File_Name]),'Table'[LOAD_TAT_Category] = ">7 Days")Measure2 = VAR _result = CALCULATE(SUM('Table'[Count of Member_File_Name]),'Table'[LOAD_TAT_Category] = ">7 Days") RETURN _result & UNICHAR(10) & FORMAT(DIVIDE(_result,SUM('Table'[Count of Member_File_Name])),"0.00%")3.Adjust the position of the line chart and place it at the top.
Best Regards,
Wenbin ZhouHi Anonymous, Thank you so much for sharing pbix file and detail explanation
Hi Sandeep13 ,
Unfortunately, in Power BI, if there is not enough space to display the label, it is hidden. In your case, I would suggest moving the Y-axis start line to e.g. 50% - then the second category will be visible.
You can also write a measure that will dynamically set the Y-axis start taking into account, for example, the smallest value for the first category.Memorable Member | Former Super User
If I helped, please accept the solution and give kudos!
LinkedinThanks for your reply. as you suggested I did the same but 0.5 was not enough so I make it 0.9 In this case numbers are apprearing but Its little confusing because when you see consumer segment 90 % is in green become very small and only 9.12 % so bigger in this category. is there any other approch ?
Below is samle data for same I using 100 % stacked column chart
Type LOAD_TAT_Category Count of Member_File_Name Commercial 0-7 Days 360 Commercial >7 Days 4 Consumer 0-7 Days 797 Consumer >7 Days 80 MFI 0-7 Days 199 MFI >7 Days 1 OLM 0-7 Days 813 OLM >7 Days 8 SUIT 0-7 Days 79 Hi Sandeep13 ,
The only option I see now is to stack the charts.
Below create a 100% stacked bar chart, disable the data label for >7 Days. Create a Line Chart that shows the Share values, invert the Y-axis so that 0% starts at the top. Disable everything possible (titles, values, background) and stack one on top of the other.
You can also disable interactions between them, and also group the two visualizations and enable maintain layer order so that no one changes the visualization order.Memorable Member | Former Super User
If I helped, please accept the solution and give kudos!
Linkedin