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

[@gospelmoto2833]

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

[@ramachandrana4173]

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.

[@yulianaweinstein733]

Extremely helpful, thank you!

[@Lutfitince]

Great Video! Thank you, Fernan!

[@hado-hado]

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.

[@EyiBillion]

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

[@cemyeten]

Oh man, this is exactly what I've been looking for. Thanks a lot. 😍😍

[@TheMisiekMisiek]

This is really good. Clear and simple, impressive.

[@arbazahmad7177]

Excellent....

[@AbouAli01006300091]

Very well done!!! love it.

[@mitikamahajanpatil3234]

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

[@حضرميالحضرمي-ز3ط]

Excellent.

[@petercompton538]

Outstanding! Thanks very much

[@Aaron-b6e]

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?

[@mohammadaamirkhan7830]

Wow, Amazing video! Thank you

[@yemiakinwande7039]

Really useful. Great job, Fernan

[@Moon_Rise6393]

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

[@muhammadsabirhussain1503]

Excellent tutorial. Awesome method of explanation.

[@katepopo-ola265]

Absolutely impressive !

[@andytran4435]

perfect. Thank you so much for these easy instructions

[@ronlieuw5272]

Thanks for sharing Fernan, very helful

[@keshavkarki7775]

much needed one thanks sir!!!

[@ahmadzuhairzaidan101]

This is extremely helpful! I tried using the same method for multiple cards for different KPIs however I got a few different slicers. How can we sync the different slicers?

[@2210gili]

Excellent!!!

[@omarabdelslam30]

I am forward to a new job needs a presentation so thanks for your video

[@jeffmiller4405]

You are awesome!!!! Great job.

[@sandyag907]

Very well done!

[@PedroCabraldaCamara]

Fantastic Fernan. Thanks 4 sharing

[@bradyarbro5397]

Thank you for the helpful video!

[@kanrongyu]

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]

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" ) )

[@Hehehe-ni8gb]

​@@danicatattoos thankyou so much

[@WaqasKhan-sp3sn]

Excellent

[@608er]

Great video. Thanks

[@mabenba]

Amazing video! Thanks for sharing.

[@arthurronnie7311]

Thanks Fenan, this is a Great video

[@zulajenkins658]

Thanks Frenen it is very useful

[@shivanihandore4738]

Very Helpful... Thank you so much

[@siddiqbinsalam1284]

very handy and helpful

[@rreneijhorst4418]

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

[@elfridtech]

Thank you🎉, help me a lot

[@tlee7028]

Excellent !

[@gagansingh3481]

Awesome fernan sir

[@Anburaj_tha]

Great content! thank you so much Ferdnand :)

[@hamishmaxa6509]

Very nice. Thanks.

[@QuantumIdeas]

This is awesome!

[@anaballesteros-sosa4007]

Great! Thank you very much

[@Kevgas]

13:00 adding diff parameters to make card dynamic

[@MiguelGarcia-ip1zd]

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

[@BestICan]

Well done!

[@jbloe555]

Very helpful. Thank you!

[@mshparber]

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

[@SKGoon-il3lf]

Thank you.

[@isBessem]

Helpful, as usual! Thank you!

[@safiqul02]

Great content

[@mohdkhairilakub8064]

Hi Fernan, can you show also how you do the measure for every sales comparison folder as well?

[@karinamatvejeva3164]

Thank, very useful!

[@patricefayard2626]

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

[@venkatc1323]

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

[@Paul.Arnold]

Just come across the video and it's exactly what I need for a dashboard reporting on net zero carbon emissions. Is there also a video explaining how to write the measures that you have here?

[@the_legends1989]

Great job ❤

[@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".

[@DataChy]

Great content. Thank you

[@TayuanRebelo]

Hey, I loved the new hair.

[@menphisp1629]

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

[@menphisp1629]

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

[@agapheputrasusilo741]

thanks fernannn

[@ax78360]

really cool tks !

[@rahulkerkar7180]

Very creative

[@norbertmahieu5513]

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]

am wondering the same.

[@manuelmendez1694]

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

[@katiawei6817]

I have the same question

[@katiawei6817]

I have the same question

[@paveljanci2124]

@@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.

[@LAssu-pv4bo]

Impressive!

[@navisalomi]

Impressive

[@fawaz84]

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

[@jordanrose8447]

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 🙏🏼

[@riyadiagung8105]

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?

[@ultimate2373]

😍 Love this nice card game

[@PHWiest]

Great!

[@raghu6772]

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

[@RedCloudServices]

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?

[@smokie4ever]

God bless you

[@AhmedEssam-m9y]

Great

[@vijaypalmanit]

Your videos have awesome content and they also rank higher in youtube search, if you enhance your thumbnail I think more people will click and watch it.

[@james_msuk]

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

[@markterwindt8522]

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

[@MeghanContet]

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

[@datalab365]

Good

[@ManuthVANN]

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 ?

[@rohangambhir880]

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

[@PriscillaHou-q5u]

How can a PowrBI report server version without a field parameter create function to make this sceario change?

[@PriscillaHou-q5u]

Hi Everyone, I came across a way to overcome powerbi Report server version's shortage on dont have the field parameter function. I just created a new sceario table in the query and dont need to connect to them, then let it equal to a variable, and create another variable to calculate the sum up of the sales in different sceario. Then replace some the KPI _ACT vs BUD formula that the author has taught us, it is dynamic again!!!! Hope that will help if anyone have same problem as I do. Cheers!

[@Andrewscottnewsom]

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.

[@l-earningmantra4222]

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

[@HarisKhan-yi3gl]

shift+enter

[@3danim8r1]

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

[@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.

[@sandeeparout9967]

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

[@juanisidrodiaz3093]

You have to enable in the option

[@SSRealEstates83]

Question? How to show the total sales in K or M. Example. Your total sales 38516. I wan show as 38 K. Thank you

[@Hehehe-ni8gb]

Go to call out value Then display unit and select the thousands

[@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.

[@TaylorSchmac]

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?

[@muhammadafiqbinmohdpauzi7767]

if i want the map color by district

[@Soulenergy31]

15:35 squeezing the card to its full potential

[@dikshasrivastava9125]

Not able to change color of kpi

[@kastenivkimbo5347]

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

[@srinivasanar659]

how will u format this the numbers are in millions or billions.. the example you showed is only having thousands.. can you show how to add K,M,bn

[@janscas]

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