Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
HDEUISSS
Regular Visitor

Searching for diagram like sunburst but horizontal

I am searching for a Power BI diagram that is like a sunburst diagram, but horizontal, so that it is easier to read the different informations on the each bar.

 

for example, I have a total of CO² emissions and want to show it by company area, company and energy type:
2024-09-26_23h42_57.png

does somebody knows such a diagram in the store, I have not found one or I dont know the name of it? Or does somebody have an idea if there is a way to use an existing visual to archive the same goal?

 

Thanks in advance!

6 REPLIES 6
parry2k
Super User
Super User

@HDEUISSS you mean first total then company then location and then energy type? Is this what you what?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi parry2k, yes that would be great if its not to much work, if we need to create a measure for each combination of group and location I cant do it because there are too much locations. Thanks for your help!

parry2k
Super User
Super User

@HDEUISSS The only issue is with colors. Although can be set manually to keep the color for energy type the same as company but not dynamic.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi parry2k, thank you very much for your help! I am not able to upload a file here but I can give some sample data using csv format. Depending of how complicated it is to have the sub info for location it would be cool if it is possible to show this as well, but if it is too much work (because maybe it needs a measure for each) that would not make sense as this date is changing to often. Thanks!

Group;Location;Type;Value
Construction;Loksite;Electric;64374
Hotel;Garden Inn;Electric;51516
Hotel;Garden Inn;Heat;40259
Hotel;Blue;Electric;250575
Hotel;Blue;Heat;43116
Elderly Care;KE;Gas;82773
Elderly Care;KE;Oil;089998
Elderly Care;KE;Electric;187420
Elderly Care;RA;Gas;137102
Elderly Care;RA;Electric;151570
Elderly Care;BU;Oil;223297
Elderly Care;BU;Electric;147107
Elderly Care;BD;Gas;1828
Elderly Care;BD;Electric;92366
Elderly Care;BD;Heat;99929
Elderly Care;SB;Gas;135160
Elderly Care;SB;Electric;179665
Elderly Care;CV;Electric;34827
Elderly Care;CV;Heat;199142
Elderly Care;EW;Electric;118888
Elderly Care;EW;Heat;87555
Elderly Care;BB;Oil;124836
Elderly Care;BB;Electric;62547
Elderly Care;KA;Gas;320953
Elderly Care;KA;Electric;100876
Elderly Care;LC;Electric;128008
Elderly Care;LC;Heat;192928
Elderly Care;LC;Electric;70633
Elderly Care;LC;Heat;364517
Elderly Care;NH;Gas;191852
Elderly Care;NH;Electric;243325
Elderly Care;PB;Electric;184068
Elderly Care;PB;Heat;243970
Elderly Care;KT;Gas;142262
Elderly Care;KT;Electric;123801
Elderly Care;ST;Electric;0
Elderly Care;ST;Heat;0
Elderly Care;BO;Electric;013
Elderly Care;WS;Gas;145471
Elderly Care;WS;Electric;164564
Elderly Care;SH;Gas;162727
Elderly Care;SH;Electric;243498
Elderly Care;SR;Electric;1574
Elderly Care;DR;Electric;90131
Elderly Care;DR;Heat;120328
Elderly Care;WW;Electric;102269
Elderly Care;WW;Heat;139931
Elderly Care;TD;Gas;438804
Elderly Care;TD;Electric;192191
City Quarter;GS;Electric;650789
City Quarter;GS;Heat;183593
City Quarter;KFGA;Electric;108053
City Quarter;KFGA;Heat;65322
City Quarter;KFGG;Electric;8166
City Quarter;KFGG;Heat;144827
City Quarter;KFGW;Electric;81489
City Quarter;KFGW;Heat;26540
City Quarter;Q6A;Electric;139558
City Quarter;Q6A;Heat;128504
City Quarter;Q6M;Electric;727141
City Quarter;Q6M;Heat;639471
City Quarter;Q6W;Electric;124994
City Quarter;Q6W;Heat;223885
City Quarter;Q7A;Electric;129982
City Quarter;Q7A;Heat;321232
City Quarter;Q7M;Electric;314884
City Quarter;Q7M;Heat;58675
City Quarter;Q7MVZ;Electric;98926
City Quarter;Q7MVZ;Heat;325460
Construction;WW19;Gas;56309
Construction;WW19;Electric;470037
Construction;WW19;Heat;425688
Construction;NLA;Gas;59721
Construction;NLA;Electric;34768
Construction;NLD;Electric;79300
Construction;NLD;Heat;6788
Construction;NLH;Oil;002
Construction;NLH;Electric;382100
Construction;NLH;Heat;22350
Construction;NLL;Electric;11742
Construction;NLL;Heat;6322
Facility;NLG;Gas;29515
Facility;NLG;Electric;374211
Facility;NLW;Gas;140360
Facility;NLW;Oil;18713
Facility;NLW;Electric;462600

 

parry2k
Super User
Super User

@HDEUISSS I tried something and it looks like this:

parry2k_1-1727390742954.png

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@HDEUISSS it should be doable with core visuals but would require some work. If you can share some sample data in excel sheet or pbix file (remove sensitive information before sharing) and I can look into the solution for you.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.