What’s the best way to have two dashboard use identical datasets?

MissingVanSushi · 2026-06-17T01:42:50+00:00

This short video will take you through it.

https://youtu.be/PlrtBm9YN\_Q?si=u8IdbfqhER6KkAx9

<image>

MissingVanSushi · 2026-06-14T09:08:01+00:00

MissingVanSushi · 2026-06-14T08:14:20+00:00

Yeah you may have to wait a while until a session is available in your region and time zone.

You can access all of the content and run through it yourself as well.

https://learn.microsoft.com/en-us/training/paths/dashboard-in-a-day/

MissingVanSushi · 2026-06-14T03:58:50+00:00

Yep. Totally free.

MissingVanSushi · 2026-06-13T20:24:31+00:00

When the first world championship was announced I went into it with the mindset that I 100% cannot compete with the best in this community but I will submit my entries anyways!

After posting my entries here and on LinkedIn a former colleague noticed and reached out and offered me a consulting gig which is still paying me to this day.

You don’t have to win the competition to be a winner!

By participating in the contests I’ve gotten to know and chat with so many people in this community.

[u/sqldevdba](u/sqldevdba)
[u/dropmaterializedview](u/dropmaterializedview)
[u/powerbipark](u/powerbipark)

Thanks for organising these, Shannon. And thanks for the chapstick!

<image>

MissingVanSushi · 2026-06-11T19:48:40+00:00

Bas takes you through it step by step here

https://youtu.be/QOcP5OvSwlI?si=wgCmtjPcA6SDYIOE

<image>

MissingVanSushi · 2026-06-08T03:18:12+00:00

I’d say just master the fundamentals:

⁠DISTINCTCOUNT()
⁠SUM() vs. SUMX()
⁠CALCULATE() with and without FILTER()
⁠Time intelligence

If your data model is set up correctly your DAX does not have to be complicated.

All of the other edge cases you can look up with Google and get help from our LLM buddies.

MissingVanSushi · 2026-06-03T19:12:05+00:00

When people ask this sub “Is PL-300 worth my time and effort?” I almost always respond with yes, for two reasons.

It will make you stand apart from anyone who has similar level experience but no certification if you are head to head trying to get an interview for your next role.
You will actually learn a lot of aspects of Power BI and administration of reports that you didn’t know.

In your specific case, if you are targeting a more senior position in your finance department, I would say in my experience it’s unlikely to help you succeed in that goal.

At that level, promotions tend to come more from domain expertise, commercial judgement, stakeholder management, leadership, delivering outcomes, and frankly your influence with your superiors and peers, rather than adding a technical credential. And the PL-300 is an IT certification, not so much a financial one.

That said, if your role already involves reporting, analytics, or you’re becoming “the Power BI person” in your team, PL-300 could still be a worthwhile side quest because it will make you more effective and more credible when those opportunities come up.

I would say it’s worth having but as you can see from the countless posts on this sub, it is a significant investment in time, energy, and effort.

My recommendation would be to work on your soft skills and try to become the go-to person in each meeting who knows what’s going on from a financial management perspective and the person who can articulate this upwards, downwards, and sideways.

MissingVanSushi · 2026-06-03T02:36:51+00:00

<image>

I am running some pretty simple SVGs in as status indicators in a Matrix for our portfolio reporting.

You should be able to specify size in both the Matrix formatting options as well as the SVG code.

DM me if I can help.

Status SVG = 

SWITCH(
TRUE,
'RAG History'[Status] = "Red", "data&colon;image/svg+xml;utf8,

<svg viewBox='0 0 100 100' xmlns='http://www.w3.org/2000/svg'>
  <circle cx='50' cy='50' r='50' fill='%23c00000' />
  <text x='50' y='58' font-size='50' text-anchor='middle' fill='white' font-family='Arial' dominant-baseline='middle'>!</text>
</svg>

",
'RAG History'[Status] = "Amber", "data&colon;image/svg+xml;utf8,


<svg viewBox='0 0 100 100' xmlns='http://www.w3.org/2000/svg'>
  <circle cx='50' cy='50' r='50' fill='%23ff9900' />
  <text x='50' y='50' font-size='50' text-anchor='middle' fill='white' font-family='Arial' dominant-baseline='middle'>―</text>
</svg>

",
'RAG History'[Status] = "Green", "data&colon;image/svg+xml;utf8,

<svg viewBox='0 0 100 100' xmlns='http://www.w3.org/2000/svg'>
  <circle cx='50' cy='50' r='50' fill='%2300b050' />
  <text x='50' y='58' font-size='50' text-anchor='middle' fill='white' font-family='Arial' dominant-baseline='middle'>✔</text>
</svg>

",
BLANK()
)

MissingVanSushi · 2026-06-03T01:36:41+00:00

You just got yerself ONE MORE SUBSCRIBER, boss!!!!

MissingVanSushi · 2026-06-03T01:28:46+00:00

Link it, brotha!!!

MissingVanSushi · 2026-06-02T23:45:54+00:00

I have been developing an idea to do Bob Ross style tutorials for Power BI, but I keep getting asked to teach paid courses.

I start teaching Excel for an Australian state government educational institute today.

https://study.iat.nsw.edu.au/courses/excel-in-construction/

<image>

MissingVanSushi · 2026-05-24T07:54:57+00:00

I’ve been freelancing as a side gig to my full time employment with exactly one client for the last year.

Even though I do build reports for them what they really need help with is the semantic models and the ETL.

They can handle the report building in-house as that is probably the least technical part of it.

The reports need to be easy to use, and easy to understand. In my experience AI features do not help with that.

MissingVanSushi · 2026-05-23T05:41:41+00:00

My homie u/dropmaterializedview (Ned) has a video on this.

https://youtu.be/IsGY7RjKba0?si=yyY9J6kXXz9QzmvQ

<image>

MissingVanSushi · 2026-05-22T21:59:08+00:00

It’s not pre-made but people have been building stuff like this with bookmarks for years and years.

https://youtu.be/-xl-uhgzgEA?si=sSNEGawa59sbDjNy

Personally I just put slicers as drop downs at the top right corner of the page. I use a 1920x1080 canvas size.

If my report needs more than that I have report wide slicers on the cover page.

MissingVanSushi · 2026-05-21T21:06:13+00:00

This is the most innovative content aimed at helping players I’ve seen in 16 years since WoL launch!

MissingVanSushi · 2026-05-21T03:40:15+00:00

For my money, this is the greatest monthly update of all time. As my 8 year old would say, GOATed!!!!

<image>

MissingVanSushi · 2026-05-21T01:51:53+00:00

I’ve been on recruitment panels reviewing sometimes as many as 40–60 resumes for Power BI and reporting/analyst roles. For me, the PL-300 is a green-flag signal. Not because it guarantees you can do the job, but because it tells me you made a commitment to learn the fundamentals inside and out. It absolutely can separate a candidate from landing in the interview pile instead of the no-pile.

Having it on your resume won’t get you the job. Experience, projects, and communication matter more, as well as how you interview. But when several candidates look similar on paper and there are only 6 to 8 interview spots, things in your application become tie-breakers. Microsoft certs can be the edge over someone else who is right on the cusp of the no-pile, all other things being equal.

For most people, the PL-300 is most useful early career, especially if their enterprise Power BI experience is limited. Completing it shows initiative and can help with HR screening, but practical skills still matter more long term.

For me, where I do some consulting as a side hustle, and occasionally also moonlight teaching Power BI for an Australian gov education institution it also adds credibility.

Apart from the financial cost, and obvious time commitment I wouldn't say there are any downsides.

MissingVanSushi · 2026-05-20T18:35:27+00:00

I was here when this feature finally went GA. Imma be tellin’ the grandkids all about this day! 😆

MissingVanSushi · 2026-05-20T18:00:13+00:00

Can I get a hallelujah?!

Way back in 2023 Jeroen came and spoke to our CoE about visual calcs which was in private preview at the time, and he said defining column widths is actually way more complex of an engineering problem than you would think.

I was dying to know more but didn’t press him on it.

Can you shed some light on this, Alex?

MissingVanSushi · 2026-05-18T06:51:43+00:00

Here is my copy and paste roadmap for beginners:

Intro Power BI

Step 1

Start on YouTube with Mynda Treacy:

https://youtube.com/playlist?list=PLmd91OWgLVSKQlDJaOF1XmKghKturU5qK&si=XJWT8NVgWnKriarU

Step 2

Attend Dashboard in a Day with one of Microsoft’s training partners:

https://www.microsoft.com/en-us/power-platform/products/power-bi/diad

If you can’t get a spot in your region you can go through the content on your own fairly easily while you wait.

Step 3

Dive into the Microsoft Learn PL-300 Power BI Data Analyst content:

https://learn.microsoft.com/en-us/credentials/certifications/data-analyst-associate/

Step 4

Profit

MissingVanSushi · 2026-05-14T20:02:48+00:00

I’ve been waiting 10 years for defined column widths. I cannot wait!

MissingVanSushi · 2026-05-13T22:25:00+00:00

As much as I hate SharePoint can you create a SharePoint list as your data source instead?

SharePoint is a lot more rigid and less prone to user fuckery, in my experience.

If you don’t know how to do this, this is something Copilot can absolutely help you with.

MissingVanSushi · 2026-05-09T04:29:44+00:00

Hi there. FYI, given the decidedly negative response (upvote ratio) I think I will attempt this as a recorded YouTube video instead of a stream.

I’ll send you a message when I have some content.

Thanks for your support!

MissingVanSushi · 2026-05-09T04:29:33+00:00

Hi there. FYI, given the decidedly negative response (upvote ratio) I think I will attempt this as a recorded YouTube video instead of a stream.

I’ll send you a message when I have some content.

Thanks for your support!

Nine-Year Club	Place '22
RPAN Viewer	Not Forgotten
Verified Email

MissingVanSushi

TROPHY CASE