Forum Discussion
BAR Chart values not showing
- 1 year ago
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 - Anonymous1 year ago
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
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
Hi Anonymous, Thank you so much for sharing pbix file and detail explanation