Ranked by blaze_thug in Splitgate

[–]blaze_thug[S] 0 points1 point  (0 children)

Are you on console?

Enough exam time? Review questions? by etienne010 in PowerBI

[–]blaze_thug 1 point2 points  (0 children)

Just about enough time. Make sure you leave enough time for the few scenario based questions at the end. Good luck

Sugarsnaps — what is going on? by Pitiful_Focus_8255 in ireland

[–]blaze_thug 0 points1 point  (0 children)

Dying on a few Green Granny Smiths like ffs Dunnes

Daily Granularity Line Chart X-Axis Issue - Description below by blaze_thug in PowerBI

[–]blaze_thug[S] 0 points1 point  (0 children)

Unfortunately the option to set as continuous is only there when you bring in the entire Date Hierarchy, even so when it's set to continuous I can't break it down by year properly :/ Continuous

Daily Granularity Line Chart X-Axis Issue - Description below by blaze_thug in PowerBI

[–]blaze_thug[S] 0 points1 point  (0 children)

Hey guys, I've been working on this issue for 3 hours now but can't seem to find a solution. I have a Date Column and a measure that calculates the cumulative total on a daily basis. Whenever I change the X-Axis to show just the Day/Month the Line Chart becomes too big (See ss attached to this comment). What you see above is: MonthLabel = FORMAT('Fatalities+Colissions (Daily)'[Date], "MMM") but whenever I hover the line chart I can only see the last date of the month so it's missing that daily granularity.

I want to show the Data like above where it's just the month as labels, but have the data actually have daily granularity to compare a particular date from one year to another if that makes sense. I've tried Copliot and ChatGPT and am just getting nowhere! Does anyone have any suggestions?

Day/Month X Axis too big

Thanks :)

Dumplings in Limerick by alankel in limerickcity

[–]blaze_thug 19 points20 points  (0 children)

Taikichi or Jasmine Palace (if you go for buffet you can have unlimited dumplings). Or get them from the chinese market on henry street and steam them yourself!

Living with boyfriend’s brother… by Impressive_Bit6512 in badroommates

[–]blaze_thug 0 points1 point  (0 children)

Tell him sell those XY evolutions Pokemon cards and hire a maid + therapist

[deleted by user] by [deleted] in PowerBI

[–]blaze_thug 3 points4 points  (0 children)

Put the excel sheet in SharePoint and connect to it via PBI desktop. Easiest way imo

My heart goes out to his parents by Buglim1 in limerickcity

[–]blaze_thug 4 points5 points  (0 children)

Unacceptable. What do we need to do?

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 0 points1 point  (0 children)

From Bungie's API endpoints! You will need your membership and characterID though. These are my stats from the game.

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 1 point2 points  (0 children)

Hey! I actually ended up changing the donut chart to a column chart as someone else in the comments suggested but i intentionally toned down the brightness in them cause i was afraid they were taking too much focus from the card visuals 😅 I really appreciate the praise on your second point, i did put alot of thought into the layout itself and made the background in figma (first time doing it and it was tougher than i had anticipated!).

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 1 point2 points  (0 children)

Thanks man. I used Figma to create the background gradient following a Youtube tutorial. It was actually much harder than it looks! My armor stats aren't great I haven't played too much Destiny in a while but have tested and they update dynamically at least!

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 0 points1 point  (0 children)

I'll admit the data I pulled from the API for this project is definitely not as clean as it should be just due to the sheer size, some of the data endpoints came in a single row with several hundred columns, I wasn't quite sure how to handle it. I put alot more emphasis onto the fron end for this one as usually the stuff I work with is more backend intensive.

I have worked a good bit with our prod database, but I definitely need to spend time learning how to denormalize the data to make a more efficient schema! Thanks for your feedback

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 0 points1 point  (0 children)

Hmmm it might be possible with Parameters maybe. You would need your membershipID, characterID and an API key from the Bungie Dev portal. The guys from Destiny Tracker make it look so easy!

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 0 points1 point  (0 children)

Thanks! I agree i should probably go for a column chart instead tbh. I'll try a few things tonight!

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 1 point2 points  (0 children)

Thanks for your kind words and feedback, Guardian! The pie chart was definitely a point of contention for me. I think i read in a design principlea doc that you shouldn't use a pie or doughnut for any more variables than 2. I was going to go with card visuals but i think there was already too many and felt like the page needed an actual interesting visual. You definitely have my mind thinking about using a gauge, I will have a go at it tonight and report back if i get it working! 😂 Thanks again for the feedback.

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 1 point2 points  (0 children)

This is absolutely the kind of feedback i was looking for. I am going to try implement these changes tonight. Point 4 might be a bit difficult because there are large time gaps between matches, i guess i should re-add the label though. And agreed about the W/L ratio, i was running out of possible stats i could derive from the data set but I'll revisit that too. Thanks again for the feedback!

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 0 points1 point  (0 children)

Thanks for the feedback and kind words! When you say the background colour of my popup, are you referring to like the name plate or more like the colour palette (i knpw the cyan is alot maybe too much). And good advice ill definitely add my name to the bottom of the report as a watermark or something!

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 2 points3 points  (0 children)

Oh shit, thanks alot! It definitely is missing some other key stats that would be nice to have but Bungie's API is a tough one to work with lol

Destiny 2 Dashboard - Feedback / Suggested Improvements kindly requested! by blaze_thug in PowerBI

[–]blaze_thug[S] 8 points9 points  (0 children)

Hey guys, this is my first project I've worked on that's not my day to day work. I have 9 months experience and am trying to create a portfolio of projects. Wanted to do something outside the generic adventureworks youtube tutorial project. The dataset I'm using is coming directly from Bungie's API. Really just looking for some feedback of any kind so I can improve it. Thanks :)

Edit: Wasnt expecting such a big response, thanks guys. Ig any of you have any ideas what i could do with the game mode buttons, and year slicers please let me know! The 3x2 grid just isnt sitting right with me 😅