Forum Discussion

Chirag4370's avatar
Chirag4370
Icon for Helper I rankHelper I
2 years ago

Total Bar in Hierarchical Bat Chart

I'm Trying to display Sub Total and Grand Total in Hierarchical bar chart.

Need Help

9 Replies

  • Chocohammer's avatar
    Chocohammer
    Frequent Visitor
    2 years ago

    HI Chirag4370 

    My guess is there is no relationship with the Date. So, if you add a second X-axis with Date, then the total looks weird.

     

    Do I understand corretly, you are triyng to make the Total out of combination EEE and Other?

     

    Have a good one

    Choco

    • Chirag4370's avatar
      Chirag4370
      Icon for Helper I rankHelper I
      2 years ago

      I forgot to mation that, but DateText table also has relation with Data table. and alson sorted.

       

      Yes, I want the combined total which is already found. Now if you see the category (EEE & Other) wise total also displayed combined total instead of category wise. I'm trying to get category wise total.

      • Chocohammer's avatar
        Chocohammer
        Frequent Visitor
        2 years ago

        Try to use the Filters like this: 

         

        I don't know how your axis are named so hope you will get the idea.

         

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Chirag4370 ,

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.