Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |