The Matrix visual makes the Most COMPACT KPI card in Power BI

[@PowerBIPark]

Microsoft has confirmed that with the planned updates to the table and matrix visualizations, the accent bars bug will eventually be patched out. It might be months or years until it does happen and the tutorial will still work without the accent bars - but I wanted to write this here for transparency :)

[@markusleucht6603]

you are the best, already ussed the measure selector and date-range switch in several dashboards. thank you and respect to the dudek of course.

[@PowerBIPark]

Nice! It's great that you were able to :)

[@050224011]

This really helped me out, thankyou. I had 50 measures in a report and had a 50 'current week' and 'previous week' measures also. Report was bloated and slow. The 'Select measure' using the SWITCH function and SELECTVALUE is so simple and elegant! Liked and subbed.

[@Jubael]

You do the coolest stuff on PBI visuals that is actually useful. Probably the only BI channel I follow on top of guy in a cube

[@PowerBIPark]

Appreciate those words man :)

[@ameliepc165]

Very interesting! Will definetly use those tips in a report I'm curently working on. I also wanted to mention that there's a way to stop the column width from changing. I'm not sure where it is for you (I have a French PBI version) but for me it's in the column options where I can untick the "automatic width" box. That way your columns wont change size. :)

[@rabibahmunir6571]

Nice Work. These KPI cards videos helped me a lot. I was looking for exactly something like this. Can you do tutorial on Period over period analysis?

[@tinaflemons263]

Excellent, I can't wait to try this.

[@christophehervouet3280]

Great post , congrats Urgently waiting on Power BI for something to constrain grid columns size (same size for all whatever values ;>)

[@PowerBIPark]

hey me too man, me too

[@Kathdela]

Thank you! This is a great tutorial! Do you have any tutorials on the field parameters/date switching? I've seen folks ask for it on these kpi videos and your suggestion, but unfortunately I'm struggling to get there, as Im really just self taught here and pretty new to Power BI. Thanks!

[@PowerBIPark]

Hey i have a video called "the best kpi cards in Power bi" that goes over it :)

[@AndyDevineUK]

This is fantastic, thank you for sharing.

[@PowerBIPark]

Thanks :)

[@arbazahmad7177]

Excellent... thanks for sharing 🎉

[@PowerBIPark]

Thank you! Cheers!

[@KroLeXz]

Great job!

[@soundbeans]

You da man! Nice work. Subscribed

[@joelluis4938]

Hi, I loved the visual but I have a doubt regarding the formulas that you are using. 1W -> Means "Week to Date" , 1M-> is Month to date, etc ? For example if today is Wednesday 11 Sept and you select "1W" you will see the data from Monday to Wednesday ? 1 Month would be since the 1st day of the month to Sept 11 ? Thanks

[@PowerBIPark]

Hey, solid question. It's actually 1 week, 1 month, 3 months- so it's not wtd mtd :)

[@workstuff5253]

Out of curiosity - the numbering in your measure names is to group or organise them, but I was curious to know your thought process was.

[@PowerBIPark]

Hey thanks for noticing! That's actually just the order by which I explain them, so that it's easier for me to do the video :)

[@nimikajadav3004]

Awesome👏👏👏👏👏👏

[@randombam001]

Please create a video on google ads and Facebook ads reporting dashboards

[@wilconagtzaam587]

Nice Injae!

[@PowerBIPark]

Thanks Wilco! Hope you're doing well man :)

[@AmauryVanEspen]

Hi @PowerBIPark could you please share the KPI Card Data.xlsx ?