NEXT LEVEL KPI CARD using NO CUSTOM VISUALS // Power BI Tips and Tricks in 2023

Рет қаралды 89,387

Күн бұрын

In this video were going to cover how you can upgrade your card visuals to show more insights, and completely customisable without using any external tools.
Link to Gustaw Dudek's LinkedIn and original solution: / urn:li:activity:705508...
🕓 TIMESTAMPS
0:00 - Intro
02:23 - The data
03:03 - Formatting the Card
05:26 - Titles & Subtitles
07:51 - Compare to Budget
11:07 - Switch Comparisons
14:19 - Adding Colours
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: fernan@solutionsabroad.co.uk
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence

Пікірлер: 101

@gospelmoto2833 9 ай бұрын

Wow! this is awewome. Im beginning to love PBI now. Thanks Fernan, you're awesome too!

@TheMisiekMisiek 10 ай бұрын

This is really good. Clear and simple, impressive.

@andytran4435 6 ай бұрын

perfect. Thank you so much for these easy instructions

@isBessem Жыл бұрын

Helpful, as usual! Thank you!

@rreneijhorst4418 11 ай бұрын

Fernand really awesome stuff! I've tried it myself and it works thanks to you mate!

@mshparber Жыл бұрын

Awesome dude! Just used in in my dashboard. Thanks a lot!!!

@Moon_Rise6393 4 ай бұрын

What a clear explanation thanks man you provided a genuinely unbelievable content Hatts off

@MiguelGarcia-ip1zd 11 ай бұрын

Que buen truco, no sabia que podia meter dos medidas en una tarjeta y como la utilizaste fue magico, gracias.

@jbloe555 Жыл бұрын

Very helpful. Thank you!

@shivanihandore4738 Жыл бұрын

Very Helpful... Thank you so much

@patricefayard2626 Жыл бұрын

It’s really great. Great job. Thanks a lot

@sandyag907 Жыл бұрын

Very well done!

@yulianaweinstein733 2 ай бұрын

Extremely helpful, thank you!

@mabenba Жыл бұрын

Amazing video! Thanks for sharing.

@falcon200881 11 ай бұрын

Great content! thank you so much Ferdnand :)

@keshavkarki7775 Ай бұрын

much needed one thanks sir!!!

@PedroCabraldaCamara Жыл бұрын

Fantastic Fernan. Thanks 4 sharing

@muhammadsabirhussain1503 12 күн бұрын

Excellent tutorial. Awesome method of explanation.

@ChyAnalyst Жыл бұрын

Great content. Thank you

@bradyarbro5397 11 ай бұрын

Thank you for the helpful video!

@mohammadaamirkhan7830 11 ай бұрын

Wow, Amazing video! Thank you

@yemiakinwande7039 8 ай бұрын

Really useful. Great job, Fernan

@jeffmiller4405 Жыл бұрын

You are awesome!!!! Great job.

@anaballesteros-sosa4007 Жыл бұрын

Great! Thank you very much

@ramachandrana4173 2 ай бұрын

This is gem of a content, just easy way to add colors at the last, since the data is in text format i used conditional formating for giving it a red or green, if it begins with '-' give me red font else green font. Its working well. Only thing is that the dash seperates the % with actual variance also change its color if you are fine with it you can follow this.

@ronlieuw5272 Жыл бұрын

Thanks for sharing Fernan, very helful

@arthurronnie7311 10 ай бұрын

Thanks Fenan, this is a Great video

@karinamatvejeva3164 Жыл бұрын

Thank, very useful!

@arbazahmad7177 Жыл бұрын

Excellent....

@mitikamahajanpatil3234 4 ай бұрын

It is a fantastic video. Used it. Looking forward to more.

@Kevgas Ай бұрын

13:00 adding diff parameters to make card dynamic

@hamishmaxa6509 Жыл бұрын

Very nice. Thanks.

@the_legends1989 Жыл бұрын

Great job ❤

@ha-pep 9 ай бұрын

The parameter function can work as a slicer, I didn't know it before Thank you for sharing; this video taught me many new things.

@eyitayoeyitayo-lawal2331 9 ай бұрын

Same here. It solved a puzzle that i have been battling with for ages. Thanks @fernan

@sauradeeppoddar7702 27 күн бұрын

Great tutorial. Awesome.

@katepopo-ola265 Ай бұрын

Absolutely impressive !

@608er 11 ай бұрын

Great video. Thanks

@BestICan Жыл бұрын

Well done!

@user-vt8jw8mz4i Жыл бұрын

Excellent.

@zulajenkins658 Жыл бұрын

Thanks Frenen it is very useful

@QuantumIdeas Жыл бұрын

This is awesome!

@tlee7028 Жыл бұрын

Excellent !

@SKGoon-il3lf 3 ай бұрын

Thank you.

@2210gili Ай бұрын

Excellent!!!

@venkatc1323 Жыл бұрын

Grt ..... keep going on ...... Pls take different types of real time use cases

@siddiqbinsalam1284 2 ай бұрын

very handy and helpful

@ax78360 Жыл бұрын

really cool tks !

@gagansingh3481 Жыл бұрын

Awesome fernan sir

@StefanHogberg-bl9xf Ай бұрын

Great video!! Can you please help me on how to use this setup for multiple KPI:s, but with one filter for "vs Budget" and "vs Last year".

@kanrongyu 8 ай бұрын

I am new to PowerBI and found your video always very helpful, thank you! For color formatting, instead of creating this complicated measure and selecting that field when formatting, can we use rules (contains "+" then green, "-" then green)?

@danicatattoos 8 ай бұрын

Yes you can! I just accomplished this in my dashboard using the following to create a new measure: Color Indicator = IF( CONTAINSTRING([YourDAXMeasure], "+"), "Green", IF( CONTAINSTRING([YourDAXMeasure], "-"), "Red", "DefaultColor" ) )

@user-bo5kv5ho2h 3 ай бұрын

This is so awesome! What if I was doing the sales of two departments and wanted "vs Last Month" to switch on both departments sales simultaneously with one click?

@suicidalking8 Жыл бұрын

Fantastic

@safiqul02 11 ай бұрын

Great content

@navisalomi Жыл бұрын

Impressive

@agapheputrasusilo741 3 ай бұрын

thanks fernannn

@rahulkerkar7180 11 ай бұрын

Very creative

@LAssu-pv4bo 2 ай бұрын

Impressive!

@ultimate2373 3 ай бұрын

😍 Love this nice card game

@PHWiest 7 ай бұрын

Great!

@markterwindt8522 8 ай бұрын

For the thousand separator, how would I be able to change it to a dot (.), instead of a comma (,)? Thanks in advance!

@ManuthVANN 9 ай бұрын

Hi , sir thx a lot for the tutorial , I wish to design the card like you did on the video , but sadly , I have got only POWER BI Version: 2.112.1421.0 64-bit (January 2023) on my pc , so may I have your suggestion of how to do it ?

@fawaz84 23 күн бұрын

Many thanks, where can I find the comparison table video?

@user-um1bd3zz9f 6 ай бұрын

Great

@datalab365 Жыл бұрын

Good

@jordanrose8447 25 күн бұрын

Incredible helpful! I work in professional sport and am using this cars visual to score current vs best testing scores! I was wondering if anyone knew an easy way to create a measure that would allow me to see latest score put into a table based on the last completed screening of just the individual in a slicer! I've figured out a way to do this for last screening date inputed into the column but I'm finding issues when the last screening completed by a player isn't the same as the latest date inputed! Any help would be much appreciated 🙏🏼

@smokie4ever 8 ай бұрын

God bless you

@raghu6772 11 ай бұрын

It nice to look in the Dashboard bro... It was more helpful in saving space in the visual bro. But I need small help bro u had change the Color in the KPI here Possible to Change the color only the Percentage bro. if possible can make the video bro

@menphisp1629 7 ай бұрын

Amazing ! thank you ! Can we colorize only the percent and not both numbers ?

@menphisp1629 7 ай бұрын

Also, how can I dynamize the number format (between millions, thousands etc)?

@james_msuk 9 ай бұрын

Is there a way to switch category too, i.e switching between total sales and products.

@RedCloudServices 2 ай бұрын

Thank you for the video. How would I create a whole report of KPI cards on a report? for example imagine an excel sheet where cell has a conditional background and KPI values? is that possible?

@TayuanRebelo 10 ай бұрын

Hey, I loved the new hair.

@riyadiagung8105 3 ай бұрын

Hi...this is very helpfull...I try to produce several card as product comparison, however I found difficulties to show the Rank for selected product in the Card. Do you have any solution?

@norbertmahieu5513 11 ай бұрын

Hi Fernan, great content: i use it in my KPI dashboards. I have a question: when you add more visuals like the one you showed (Total Sales) how can you combine all the comparison slicers into 1 slicer ie vs Budget, vs Last Year etc. I now get multiple parameter slicers for KPI_01, KPI_02, KPI_03. Hope you can help me out! Thanks in advance!

@paveljanci2124 11 ай бұрын

am wondering the same.

@manuelmendez1694 10 ай бұрын

Did you ever figure this out? I am having the same issue

@katiawei6817 9 ай бұрын

I have the same question

@katiawei6817 9 ай бұрын

I have the same question

@paveljanci2124 9 ай бұрын

@@katiawei6817 You can achieve identical result using tabular editor and new card visuals. Write the code into tabular editor and create card visuals just to display values.

@user-vs8dm1oi1d 5 ай бұрын

how would you do the red and green colours only for the % figure and not the figure next to the |

@rohangambhir880 9 ай бұрын

in my case it gives an error can not compare text to intergers, can you help me in this please ?

@Andrewscottnewsom 11 ай бұрын

KPI Color will not work for me. I get an error related to the comparison parameter. "Column Comparison is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression". I've researched w/o luck. Any ideas? Thanks!

@faridaakbarli Ай бұрын

I dont have this option in the latest upgrade.

@workstuff5253 Жыл бұрын

Love the video, but I am getting a strange result. It works as described if the dataset is in the pbix, but if I try to do this with a thin report, the subtitle conditional format won't let me select the field. I have even tried copying across a working one and it breaks in the thin report. I suspect its a bug in the new visual.

@hendrik-stack22 Жыл бұрын

did u add the step & " " to the measure? This is necessary in order to format the measure as a text.

@workstuff5253 Жыл бұрын

@@hendrik-stack22 yep. And this worked in the combined file - but not in the thin report.

@user-hk2bd3us1r 10 ай бұрын

when using the FORMAT() function, I lose the ability to convert data type and only 'Text' is available. I noticed in this video you do not have the same problem. do you know why this is?

@l-earningmantra4222 10 ай бұрын

Hi i have a doubt it might be a silly doubt,how to go to next line for defining variable??

@HarisKhan-yi3gl 5 ай бұрын

shift+enter

@3danim8r1 Жыл бұрын

Nice...but if the number in Billions will that format work

@muhammadafiqbinmohdpauzi7767 2 ай бұрын

if i want the map color by district

@sandeeparout9967 Жыл бұрын

I am unable to see Title and Subtitle on under visual why? I have got the latest PBI model.

@juanisidrodiaz3093 6 ай бұрын

You have to enable in the option

@ArunJebastin Жыл бұрын

Great job. Good content. One request, please keep the mic away from the screen. Its a too much distraction and bothering the eyes a lot.

@dikshasrivastava9125 11 ай бұрын

Not able to change color of kpi

@Soulenergy31 10 ай бұрын

15:35 squeezing the card to its full potential

@kastenivkimbo5347 9 ай бұрын

Its not tkaing up the code after | " & _sign & format(_var,"#0,#")

@janscas 8 ай бұрын

You are evaluating two times total sales and the comparison method. You should hold that into variables inside each measure when you use them more than one time