Forum Discussion

HabibAdil's avatar
HabibAdil
Helper IV
5 years ago
Solved

Stack Bar Chart Missing Categories

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


Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • HabibAdil's avatar
      HabibAdil
      Helper IV
      5 years ago

      Hi Anonymous 

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.