BAR Chart values not showing

[Sandeep13]

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. 

@BI @Microsoft @power @ExpertBM 

[lkalawski · Accepted solution]

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

[Sandeep13 · Accepted solution]

Hi @lkalawski Thanks for your idea.

Request you to please share PBIX file for  reference.

Hi @lkalawski  Pleae share me .pbix file so I can take it as a refrence for my other Tile and reports. Thanks in advance.

[v-zhouwen-msft · Accepted solution]

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 Zhou

[Sandeep13]

Hi @v-zhouwen-msft, Thank you so much for sharing pbix file and detail explanation

[lkalawski]

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!  Linkedin

[Sandeep13]

Thanks 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

[lkalawski · Accepted solution]

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

[Sandeep13 · Accepted solution]

Hi @lkalawski Thanks for your idea.

Request you to please share PBIX file for  reference.

Hi @lkalawski  Pleae share me .pbix file so I can take it as a refrence for my other Tile and reports. Thanks in advance.