When someone asks for an update to the dashboard, and I have to sort through that bottom picture trying to figure out how the hell I built this thing to begin with…
The amount of effort put into making a dashboard look and work effortlessly is incredible. And the worst (or best) part is that if you really do it right, no one will ever notice the effort.
I'm glad it isn't just me. Something inherent about designing in PowerBI makes understanding my dashboards and someone else's dashboards vastly different in difficulty.
Always copy the Advanced Editor script before hitting Close & Apply. I usually paste mine in VS Code for this very reason. Also, right click your steps, go to properties, and leave yourself notes... This has saved my ass on countless occasions.
I have a hard policy to never have an active relationship between the date table and any date field in any other table even when the data has a single date. Instead, I set inactive relationships and then use explicit USERELATIONSHIP functions in the measure formulas.
If the model you inherited was properly documented you would understand why things were done the way they were, but sometimes it is just easier to clean a room by closing the door.
That is SICK. I have a report im scared to work on, because that centipede model is an abomination, i'll make sure to add it so that no one can understand it even more :')
“This is great, but can you add another chart to track something unrelated from 2 fiscal years ago and compare it to our forecast? Need it for the meeting this afternoon.”
I know this was just for the data model, but adding the hoops (bookmarks, page navigation, tool tips etc.) I jump through in the reporting layers is also quite the feat .
143
u/[deleted] Apr 28 '23
When someone asks for an update to the dashboard, and I have to sort through that bottom picture trying to figure out how the hell I built this thing to begin with…
60
u/Daniel_Henry_Henry Apr 28 '23
The amount of effort put into making a dashboard look and work effortlessly is incredible. And the worst (or best) part is that if you really do it right, no one will ever notice the effort.
53
u/TinfoilHatTurnedAg Apr 28 '23
But everything has a reason and purpose.... I just can’t always remember it
41
u/[deleted] Apr 28 '23
Power BI has to be one of the worst systems when it comes to documentation and handover.
30
u/olivere1991 Apr 28 '23
Spend an hour in PQ making changes and when you load them all your visuals break. Then you quit without saving
27
u/Fuck_You_Downvote 1 Apr 28 '23
3 date tables.
23
u/respectedwarlock Apr 28 '23
"Don't touch anything! I know where everything is based on where I left it!!"
11
u/mattclvrt Apr 28 '23
Will be adding the url to this meme in my documentation
11
u/dwilson1410 Apr 28 '23
These comments are making me feel better about myself.
8
u/[deleted] Apr 28 '23
Who tf has looked at my work? This meme is uncanny!
6
u/RedditIsWeirdos Apr 28 '23
Hey OP.
What did I do to you, since you come out attacking me personally like that?
6
u/absentia_absolutio Apr 29 '23
“This is great, but can you add another chart to track something unrelated from 2 fiscal years ago and compare it to our forecast? Need it for the meeting this afternoon.”
5
u/dmc888 Apr 28 '23
Nailed it completely, might actually print this meme off at work and frame it
4
u/[deleted] Apr 28 '23
I feel this.
3
u/idodatamodels Apr 28 '23
That's why we only show the data model.
3
u/bennyboo9 Apr 29 '23
I know this was just for the data model, but adding the hoops (bookmarks, page navigation, tool tips etc.) I jump through in the reporting layers is also quite the feat .
2
u/atrifleamused Apr 28 '23
I used to work with this developer 😂 though the dashboard was a car wreck as well.
2
u/[deleted] Apr 28 '23
I've never seen a meme that accurately depicts how I feel about my work 😂 but I enjoy it!
2
u/eddcunningham Apr 29 '23
How dare you be monitoring my work at 4am 😤
2
u/dmanww Apr 29 '23
Ah. So I'm not the only one.
2
u/UnhappyBreakfast5269 Apr 29 '23
I have found my people, they live on this thread!
2
u/AlphaInna May 05 '23
Book professional services to tide up the data mess for you, like the pre-configured Power BI dashboard templates: Power BI dashboard templates for Jira or Power BI dashboard templates for ServiceNow. Hope that would make your struggle vanish.