Jeff "Dash-bored" Weir
@insightsmachine.bsky.social
I like talking about data visualisation and actionable insights in Power BI, and pushing for better vis & UI/UX.
Looks sooo productive. Heck I only just planted corn seeds in the weekend. Wonder if they will have time to mature?
November 12, 2025 at 9:40 AM
Looks sooo productive. Heck I only just planted corn seeds in the weekend. Wonder if they will have time to mature?
I think you’d have more success with a thumper and a maker hook.
a man is standing on top of an ambulance from sunney county
ALT: a man is standing on top of an ambulance from sunney county
media.tenor.com
November 11, 2025 at 8:07 AM
I think you’d have more success with a thumper and a maker hook.
Of course, I could write DAX to conditionally filter those measures from other fact tables. But then I end up generating complex DAX to prevent a naughty relationship. :-)
Sometimes my commitment to naughty relationships is stronger.
Sometimes my commitment to naughty relationships is stronger.
November 11, 2025 at 4:17 AM
Of course, I could write DAX to conditionally filter those measures from other fact tables. But then I end up generating complex DAX to prevent a naughty relationship. :-)
Sometimes my commitment to naughty relationships is stronger.
Sometimes my commitment to naughty relationships is stronger.
Yup they are from different fact tables.
November 11, 2025 at 4:15 AM
Yup they are from different fact tables.
and you show it by humming "Blowin’ through the jasmine in my mind…" but massacring the words.
November 11, 2025 at 4:08 AM
and you show it by humming "Blowin’ through the jasmine in my mind…" but massacring the words.
And this is where Data Vis meets Data Modelling. Data Modelling is like "Hey, you need to put everything in the same table" and Data Vis is like "Oh you think that a report should be structured to suit *you*, now? How cute!"
November 11, 2025 at 4:06 AM
And this is where Data Vis meets Data Modelling. Data Modelling is like "Hey, you need to put everything in the same table" and Data Vis is like "Oh you think that a report should be structured to suit *you*, now? How cute!"
Yup I understand that. Only thing is that I want my table to show OTHER measures too, which either requires those measures to be rewritten to only kick in in the cases where Leave Days isn't blank, or I'm guessing I write a Calc Group that supresses measure results when Leave Days is crossfiltered.
November 11, 2025 at 4:03 AM
Yup I understand that. Only thing is that I want my table to show OTHER measures too, which either requires those measures to be rewritten to only kick in in the cases where Leave Days isn't blank, or I'm guessing I write a Calc Group that supresses measure results when Leave Days is crossfiltered.
Hmm...even if I have an Emp DIM and Emp Fact, I don't understand how I'm going to meet the requirement that someone clicks on the Annual Leave calendar heatmap visual and sees a list of names of people who have leave booked on that day, without a relationship between Emp Fact and Leave Taken.
November 11, 2025 at 2:36 AM
Hmm...even if I have an Emp DIM and Emp Fact, I don't understand how I'm going to meet the requirement that someone clicks on the Annual Leave calendar heatmap visual and sees a list of names of people who have leave booked on that day, without a relationship between Emp Fact and Leave Taken.
This is also why I made some date relationships inactive...so that USERELATIONSHIP was a safety.
All this is for a very small org of <1000 people, btw with no Power BI development capability going forward. I'm just building a dashboard as a contractor, and documenting my approach for the next one.
All this is for a very small org of <1000 people, btw with no Power BI development capability going forward. I'm just building a dashboard as a contractor, and documenting my approach for the next one.
November 11, 2025 at 1:13 AM
This is also why I made some date relationships inactive...so that USERELATIONSHIP was a safety.
All this is for a very small org of <1000 people, btw with no Power BI development capability going forward. I'm just building a dashboard as a contractor, and documenting my approach for the next one.
All this is for a very small org of <1000 people, btw with no Power BI development capability going forward. I'm just building a dashboard as a contractor, and documenting my approach for the next one.
I also considered doing away with the relationship between Date and Leave Taken and instead doing any date filtering in DAX i.e. summing leave taken when dates fall between SELECTEDVALUE(Calendar[Date]). But that seemed like I was just trading relationships for compute.
November 11, 2025 at 1:09 AM
I also considered doing away with the relationship between Date and Leave Taken and instead doing any date filtering in DAX i.e. summing leave taken when dates fall between SELECTEDVALUE(Calendar[Date]). But that seemed like I was just trading relationships for compute.
Ditto for the Leave Taken table...I was thinking "If all I want is their names, maybe I should bring their names into the Leave Taken table"
November 11, 2025 at 12:58 AM
Ditto for the Leave Taken table...I was thinking "If all I want is their names, maybe I should bring their names into the Leave Taken table"
Ah. This is something I was thinking about doing but wasn't sure if it was considered good practice. At the same time this is a pretty small data model that is only being used in an unsupported way to drive a single dashboard. But I'm keen to understand what "good" would look like for when I need it
November 11, 2025 at 12:56 AM
Ah. This is something I was thinking about doing but wasn't sure if it was considered good practice. At the same time this is a pretty small data model that is only being used in an unsupported way to drive a single dashboard. But I'm keen to understand what "good" would look like for when I need it
I have two date relationships between Date - one to "Joined Date" and one to "Last Day" - so that I can then construct the following visual, that uses these relationships to group starters/leavers by month.
November 10, 2025 at 11:44 PM
I have two date relationships between Date - one to "Joined Date" and one to "Last Day" - so that I can then construct the following visual, that uses these relationships to group starters/leavers by month.
Where are you that it is still weekend?
November 10, 2025 at 3:33 AM
Where are you that it is still weekend?
Do you bother pinching out laterals?
I’m becoming increasingly lazy. I made up some tomato cages using mesh I bought from Bunnings and just put the cages around non dwarf varieties and let them go nuts.
Maybe I should do a/b testing
I’m becoming increasingly lazy. I made up some tomato cages using mesh I bought from Bunnings and just put the cages around non dwarf varieties and let them go nuts.
Maybe I should do a/b testing
November 9, 2025 at 6:04 PM
Do you bother pinching out laterals?
I’m becoming increasingly lazy. I made up some tomato cages using mesh I bought from Bunnings and just put the cages around non dwarf varieties and let them go nuts.
Maybe I should do a/b testing
I’m becoming increasingly lazy. I made up some tomato cages using mesh I bought from Bunnings and just put the cages around non dwarf varieties and let them go nuts.
Maybe I should do a/b testing
Really dissatisfied with the variety of tomatoes at the two garden centres I visited.
I haven’t seen the delicious green zebra variety for years; the only non red/yellow variety was Black Krim; didn’t see any heirloom sections. My bad for not saving seed.
I haven’t seen the delicious green zebra variety for years; the only non red/yellow variety was Black Krim; didn’t see any heirloom sections. My bad for not saving seed.
November 9, 2025 at 9:21 AM
Really dissatisfied with the variety of tomatoes at the two garden centres I visited.
I haven’t seen the delicious green zebra variety for years; the only non red/yellow variety was Black Krim; didn’t see any heirloom sections. My bad for not saving seed.
I haven’t seen the delicious green zebra variety for years; the only non red/yellow variety was Black Krim; didn’t see any heirloom sections. My bad for not saving seed.
Somehow I have managed to squeeze 50 tomato plants in to the beds this weekend as well as the other usual zucchini and cucumber and sizeable block where I’ve put corn seeds.
Everything will be fighting for elbow room.
Hopefully I can keep the Pātaka kai stocked when the time comes.
Everything will be fighting for elbow room.
Hopefully I can keep the Pātaka kai stocked when the time comes.
November 9, 2025 at 8:58 AM
Somehow I have managed to squeeze 50 tomato plants in to the beds this weekend as well as the other usual zucchini and cucumber and sizeable block where I’ve put corn seeds.
Everything will be fighting for elbow room.
Hopefully I can keep the Pātaka kai stocked when the time comes.
Everything will be fighting for elbow room.
Hopefully I can keep the Pātaka kai stocked when the time comes.
But I understand that real developers can do more real developer stuff these days…
learn.microsoft.com/en-us/power-...
learn.microsoft.com/en-us/power-...
Git integration with Power BI Desktop projects - Power BI
Learn about Git integration with Power BI Desktop projects and streamline your development processes, source control, and collaboration with Git repositories.
learn.microsoft.com
November 8, 2025 at 7:26 PM
But I understand that real developers can do more real developer stuff these days…
learn.microsoft.com/en-us/power-...
learn.microsoft.com/en-us/power-...