Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
I am trying to visualise some simple data from an excel spreadsheet, no measures or complicated filters used. I have experienced this is in the past but changing scale type would fix it. The stacked bar chart does not show a category (HAAS VF4) enclosed in red thick lines in the left side picture. Just above in another plot, in the enclosed green thick lines, it is shown. When I apply the Work Centre Filter for HAAS VF4, it can be seen as well. Please can you suggest what I am doing wrong? Thanks, Habib
Solved! Go to Solution.
Hi @HabibAdil ,
As checked your pbix file, the problem is caused by too much values display on the visual(see below screenshot). Please try to switch the visual to custom visual Stacked Bar Chart by Akvelon and check whether the data can display normally. Any comment or problem, please feel free to let me know.
Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi @HabibAdil ,
Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.
Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi @HabibAdil ,
This problem may be caused by the aggregation value of the Work Centres List as "HAAS VF4" is very very little in all selected date range, so it cannot be displayed. You can try to make the stacked bar chart which mark with red circle in below screenshot bigger enough or change it to table visual to check whether it can display the data with the Work Centres List as "HAAS VF4"...
Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi @v-yiruan-msft
Thanks for your reply. The issue seems to be caused by aggregation. When I create a simple stacked graph, I can see HAAS VF4. I can also see large values for HAAS VF4 when I convert the aggregated stacked graph to table. The HASS VF4 values are large enough to be seen, you can see this in the picture I uploaded with question, after applying the filter and also in the top left hand picture.
Many thanks, Habib
Hi @HabibAdil ,
Thanks for your reply. Is there anything else about this thread need help from my side? If no, could you please mark it as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.
Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
I followed your suggestion, but the problem still presists as described in my previous reply. Thanks, Habib
Hi @HabibAdil ,
Could you please provide your sample pbix file(exclude sensitive data) in order to make troubleshooting? Thank you.
Best Regards
Rena
Hi Rena, @v-yiruan-msft
Please find link to the file.
https://oxeng-my.sharepoint.com/:u:/g/personal/habib_adil_oxeng_co_uk/EWn9rOT8hapCmVeqPTXwhfEBWXeQjz...
Kind Regards, Habib
Hi @HabibAdil ,
As checked your pbix file, the problem is caused by too much values display on the visual(see below screenshot). Please try to switch the visual to custom visual Stacked Bar Chart by Akvelon and check whether the data can display normally. Any comment or problem, please feel free to let me know.
Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |