- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
@BI @Microsoft @power @ExpertBM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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! |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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! |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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! |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
05-15-2024 10:45 AM | |||
03-28-2024 04:27 AM | |||
02-06-2024 01:50 AM | |||
05-02-2024 02:20 AM | |||
05-04-2024 05:31 AM |
User | Count |
---|---|
113 | |
77 | |
55 | |
54 | |
43 |
User | Count |
---|---|
183 | |
119 | |
77 | |
65 | |
56 |