Forum Discussion

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago

Show All Categories on X Axis

Hello,  I am currently building two bar charts and I need some help with X-Axis formatting.  The problem: In Chart 1) I am looking at a sub-group's performance, their "time buckets" only go up to ...
Need Help
Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

ExcelMonke 

 

im not sure. 

maybe you enable the show items with no data. 

 

if not, maybe sharing the file if possible so i can take a closer look . 

 

 

best regards,

  • ExcelMonke's avatar
    ExcelMonke
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    Thanks, that is how I got it to work on Excel, but I have not been able to find a similar button/option on Power BI. Any help finding it is also appreciated 🙂 

    • Daniel29195's avatar
      Daniel29195
      Icon for Community Champion rankCommunity Champion
      2 years ago

      ExcelMonke 

       

      you just need to right click on the column name. ( or click on the arrow down ) 

       

       

      hope this helps . 

      • ExcelMonke's avatar
        ExcelMonke
        Icon for Impactful Individual rankImpactful Individual
        2 years ago

        Hmmm, unfortunately that was not *quite* what I needed. It does show additional categories, however not at the level of the main group. For example, bucket 240 is still missing.