Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm Trying to display Sub Total and Grand Total in Hierarchical bar chart.
I have created similar kind of situation using dummy data. refer below link to get .pbix file.
https://drive.google.com/file/d/1pxEZDFeoR_8LqGJfMdDcNQCN6O2D2YXI/view?usp=sharing
Hi @Chirag4370 ,
It's asking for password to access the file.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsContinues to ask password.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI @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
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.
Try to use the Filters like this:
I don't know how your axis are named so hope you will get the idea.
Total bar repeat Grand total in all three categories (EEE, Other & Total). I'm trying to get category wise Total in EEE and Other and Grand Total as 3rd category Total.
User | Count |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |