New Card Visual Tutorial - Power BI (June 2023 Update)

[@syednayyar]

I have 5 hours left for a demo and this tutorial ... saved my day ... amazing..!

[@PowerBIPark]

nice :)

[@gonzalosanchez401]

Really good video! May I please know what key did you press to select every SUM_Gross Sales in your measure and modify all of them at once in 13:57. Thank you!

[@asam]

Exactly - How did he do that!

[@PowerBIPark]

Thanks for the feedback! You can achieve this effect with the shortcut [ctrl] + [shift] + [L] :)

[@VistaBalls]

@@PowerBIPark

[@joaorataoo]

I really like the calm manner and rhythm you apply in your explanations. The new look Card finally frees us from all the constraints that big brother had. Keep up your excellent work. Thanks!!!

[@PowerBIPark]

Thanks so much for the feedback! I was really excited with the new visual, and I can't wait for the more things they will release 😁 Microsoft has said this is actually a "quick win" For them, and more things will come

[@simonolivares3335]

X2...subscribing to channel for more videos like this, great work!

[@nipunsrirangam]

great Insights from video. 14:05 how you added [_sum sales] in 3 places at once? there is any shortcut to select all?

[@PowerBIPark]

Hey so if you have some text selected, you can hit Ctrl + shift + L then you can achieve that effect

[@nipunsrirangam]

@@PowerBIPark thank you :)

[@federicopastor9400]

I like the Kerry Kolosko's SVG ideas. Great video. Thanks

[@PowerBIPark]

Glad you like them! I'm hoping we'll see some for FP20 and DataDNA :)

[@beingrishi6450]

13:59 How did you do that? Selecting multiple sections at one instance

[@CrazyGadgetss]

ctrl + shift + L

[@nareshsuglani9623]

Great find, as I was looking for a way to add different icons to a multi-row card. The key here is to have separate measures for each icon you want to display. That way you can then customise each card as required.

[@MrAszpic]

I saw this video and had to suscribe, keep up with this kind of pro content, and thank you for sharing!

[@PowerBIPark]

Thanks for the feedback, glad you found it useful 😁

[@bennydonnelly1700]

Beutiful video I was really stressing but you allowed me to complete this, and my boss loved it thank you

[@PowerBIPark]

I'm glad you were able to do something with it 😁

[@brianjulius6401]

Great video! Covers a LOT of new functionality in a relatively short time.

[@PowerBIPark]

Thanks again Brian! Honestly, this is right up my alley - and I just had to get it out before my long weekend :)

[@mudassirsyedrashidali9787]

👁👁

[@sojuturnip]

Excellent description of the new card. Thanks

[@PowerBIPark]

Glad you like it! I'm going to make a new video soon to help people understand reference labels :)

[@manjeshjk]

I liked it and learned something new. Awesome.

[@oricchannel2811]

Nice tutorial. Won my LIKE and my subscription. Thank you for sharing !!!

[@PowerBIPark]

Awesome, thank you!

[@oreoresi31]

Thanks for the consistent quality content! Really helping me master Power BI. Had to drop a like and comment :)

[@PowerBIPark]

Thanks man 😂 Dia this season?

[@oreoresi31]

@@PowerBIPark I wish 💀 I'd rather chill out together again when i get the chance 😌

[@mohammadaamirkhan7830]

Nice video with good detail explanation. Thank you very much!

[@timosborn73]

Thanks Injae, a warning to users, if you add the image but nothing happens, you may need to adjust the image size, an option that is just below the image url setting. For some reason my defaulted to 0 and I couldn't work out why I couldn't see it!

[@elenuchy10]

thanks!!!

[@backgrounding4821]

Another very informative from Power BI Park. (Y)

[@PowerBIPark]

Thanks for the support 😁

[@priyanksharma3964]

13:57 Hi, what short keys used to replace Measure Names in one go at 13:57?

[@PowerBIPark]

Hi, when you have something selected, try the short cut Ctrl + shift + L

[@nicog6815]

Hi, thanks for this video. Could you please tell me how you replaced all the values with only one action at 13:57 ? Thanks !

[@PowerBIPark]

Hey, I made a quick video about this. Hope it helps! kzbin.info/www/bejne/m2jcqXaHeseYj9U

[@nicog6815]

​@@PowerBIPark Thanks so much !

[@karinamatvejeva3164]

🔥Thank You!!! As always very clearly and useful. I like 👍 it!!!

[@PowerBIPark]

Glad you liked it!

[@HugoVenturini]

Excellent exposure of this feature, Injae!

[@PowerBIPark]

Thanks Hugo! I haven't managed to get into the Drillthrough part here, but I think that's going to bring the card to the next level 😁

[@antonycatella5901]

Very informative video Injae. The options available for the new card visual are amazing

[@PowerBIPark]

Glad it was helpful!

[@EdwinYap-h7b]

13:58 how do you do that?

[@PowerBIPark]

Hey so this is a nice trick where you can press Ctrl + shift + L to highlight the same text everywhere. It's great, try it 😁

[@herrsan]

13:54 how did he select all "SUM Gross Sales" entries and changed them at the same time? Can anyone please tell me?

[@fionadu-chan9531]

This is absolutely brilliant!!! Thank you Power BI Park!

[@jaahnnavir4933]

This is a very crisp yet detailed video highlighting the features. Thank you for this. This new feature is definitely gonna help with revisualising KPIs

[@PowerBIPark]

Thanks for the feedback 😊 I'm glad you find it useful

[@davida.taylor8444]

Very cool, thanks for showcasing this.

[@777tmack]

is the number formatting option not available in the advanced chart? I see it the standard card visual but not the advanced card?

[@gmurtaza]

You sir, are a legend. Contrary to the usual PBI wizards out there with their zany and loud videos, yours was a pleasure to watch. Keep on keeping on!

[@PhilcoCup]

Darn! first video I see from your channel, high quality! a little bit fast on the last part, but you had already explained everything the rest is just experimenting, nice resource for the SVG images. Subscribed!

[@PowerBIPark]

Thanks for the feedback! Im really happy this one is valuable to a lot of people - I've been blown away by the response

[@slactran]

Thank you for this great video. I have one question though. What if I don't have the option to save my measure to the Image URL? I only have Longitude and Latitude as options in my Data Category? Thank you.

[@StephenRogers-w6b]

Excellent tutorial and demonstration of this great new feature.

[@PowerBIPark]

Many thanks!

[@dthibby]

@13:59 how did you auto select all fields to update at once?

[@PowerBIPark]

It's ctr shift l. Here's a quick video explaining kzbin.info/www/bejne/m2jcqXaHeseYj9U

[@hyonja6272]

Brilliant! Thank you 🎉

[@PowerBIPark]

Glad you liked it!

[@brad7648]

@13:59 you replaced multiple of the same values in that measure at once. How did you do that?

[@PowerBIPark]

Hey, its ctrl+shift+L. Here's a quick 3 min video about it + other shortcuts kzbin.info/www/bejne/m2jcqXaHeseYj9U

[@brad7648]

@@PowerBIPark Thank you so much. This will be a huge time saver for me. Great videos btw!

[@oh_no]

Great video! Beginner question: how did you replace all instances of the measure at the same time?? @14:05

[@PowerBIPark]

Thanks! You can a heive this with the shortcut Ctrl + shift + L 😊

[@oh_no]

@@PowerBIPark thanks!

[@Milhouse77BS]

00:49 I use the Microsoft Store version of Desktop at work since I can’t install programs at work.

[@PowerBIPark]

Boo for oversecurity :(

[@maryampour8914]

Very nice setup, thanks for sharing 😊

[@PowerBIPark]

Thanks for watching!

[@walterstevens8676]

Great video. How do I hid th visuals pane the way you have it? I always battle with the data pane being so cramped...

[@denwo1982]

At 13:59 how did make select the same measure name and type over?

[@PowerBIPark]

You can achieve this by pressing ctrl+shift+L 😊

[@denwo1982]

@@PowerBIPark thanks! First time I have seen your channel, very impressive! Keep up the good work

[@PowerBIPark]

@@denwo1982 thanks, it's a hobby 😁

[@mohamedamine4425]

👌👌👌 informative video

[@chandanamb9061]

Hi, i tried almost same thing and my data had grade and no. Of students.. But the graph isn't showing up, is there any way to varify if the graph is being created properly before adding it to the card

[@InfotainingMemes]

Thank you! Park. Long time. Could you please elaborate a short you posted about different fonts using the html visual? That looks really helpful and game changing. I watched that short n number of times and tried making it work but I got stuck everytime.

[@PowerBIPark]

Hi, so I go through the technique at length here: kzbin.info/www/bejne/h4mwfqOXl62DiZY I hope this helps!

[@InfotainingMemes]

@@PowerBIPark Sure it is, thankyou! :)

[@stevannsevellec1692]

Hi, and thanks for this tutorial. For me, the image doesn't show up in the card whereas i followed the measure and the URL Image format ? Any guess ?

[@PowerBIPark]

Did you try changing the pixel size?

[@stevannsevellec1692]

@@PowerBIPark Thanks very much for your answer. I guess you talk about x='0px' y='0px' ? If so, i've just tried with no result (i have the logo of the image in the card but not the graphic...) It seems so easy in your video. Quiet frustrated 🥲

[@just_pbi]

Very nice! Thank you for sharing! Quick question, I noticed that you altered the sparkline measure by renaming all measures of "Sum Gross Sales" to "_sum sales" simaltaneously. Please explain how you do that all at once?

[@PowerBIPark]

you can acheive this by using the shortcut ctrl + shift + [L] :)

[@just_pbi]

@@PowerBIPark Thank you so much!

[@h.parwani6521]

Loved the ctrl shift L trick! Thanks!!

[@karmalin9093]

life-saver hack!! Thank you so much for sharing!!!

[@zeeshansiddiqui2000]

Very helpful video!!! Thank you for such good work

[@PowerBIPark]

Glad it was helpful!

[@Nabil_ZAR]

Excellent video! Please how to multi-select and change same fields on DAX code level? Thanks

[@mariapradeepm]

Excellent one, Thanks a lot for taking time, really useful!

[@JenTopp]

I copied in the Kerry Kolosko code and changed the date field to apply to my data. It is highlighting the VAR SVGImage URL and saying it is incorrect???

[@julesr617]

Thanks for a very helpful video! Is this possible to achieve for a Sparkline added to a column in a table/matrix table. Also, will this work and appear the same when uploaded and viewed in the service?

[@Khan-mc3gi]

Wow great u explain easy way although i am thinking i will need to learn this code but u save time and tell us without learn code u can do this that great👍

[@vinayak254]

Thank you very much for the information. I will try to use it in my report. Great !!

[@PowerBIPark]

Glad it was helpful!

[@RedCloudServices]

can these new cards be flipped to show additional data?

[@alicevaleina3479]

Can you please provide a link for finance data?

[@ichiaidoify]

Hi thanks for the explanation. Don't we have any possibility to display targets and targetranges along with the specific values?

[@PowerBIPark]

Hey, this is totally possible but I don't have the code. I've definitely seen some people do this on linkedin

[@mohitlalwani6441]

Thanks for the video! However, I'm running into a problem wherein I am unable to change the data category of the measure I have created to Image URL. The only 2 active options are Postal code and bar code. How to solve the issue ?

[@PowerBIPark]

sounds like a weird edge case - have you tried other measures?

[@tamerajohnson1730]

Great video. On the Image URL Feature--I am trying to add an image URL to 2 of the cards. I have selected all under Cards--Apply setting to all--then I chose under image none. After that, I selected the card that I wanted the image URL-it adds this to the card but it defaults to all cards to have the Image (from the URL). When I chose the 2nd card for a different image url, it won't show the Image. However, the 2nd URL Image shows on the other cards. The 2nd URL Image card won't even show the first card Image--So essentially all cards but the 1st and 2nd url cards show the 2nd image but the 2nd card doesn't show ANY image. By the way--on the Image URL--it shows the text of the URL (I have changed the Data Category in the formatting to Image URL)--I tried to turn it off by choosing the selected card under Callout and turn it off--but it turns it off for all cards. So what I ended up doing was on the cards with the Image url--i changed the font color to White. Is there a bug or am I missing something?

[@PowerBIPark]

Hey, so I'm writing from mobile so might need to respond again later - the URLs showing text the measure data type needs to be changed to "image URL". Let me know if that works! Also, the images work really annoyingly - if you set an individual series to be different reverting to all doesn't always select all the cards again

[@tamerajohnson1730]

@@PowerBIPark on the image URL--it is sent to image URL--however, it still shows in the data category. If it turn off the data category for just the individual selection--it turns it off for ALL of the categories. That is why i just did the font to white (I don't have a background) so it would work. If you have any suggestions on how to work with the all and the individual series to try to make this work, I am open to try some things. Thank yo so much for your help. This is a great visual, just need to get the kinks worked out.

[@tamerajohnson1730]

@@PowerBIPark If there is a place I can upload a picture, please let me know.

[@MohamedElMansour-g1d]

Great video but please one quick question can you tell me about a website to download those images you made in the video for the card visual

[@PowerBIPark]

It's in the description, it's wanicon from felxicons 😊

[@K_dyub]

Great stuff. The svg part gets me wondering about all other possibilities with that feature...

[@andreagazmin]

Where do get your clipart?

[@KedielSanchezMariano]

Really awesome. Thanks for the video!!. I see that you have the "Build a visual" panel when you hover over a visual. How do I enable that option? I'm trying to have it like that.

[@PowerBIPark]

You just need to enable the "on object formatting" In the preview features 😁

[@Blackday2010]

Great tutorial by a great person

[@cameronweston1038]

Great Video. I am Using this Card to Drill through so I am using it as a Button. I have a clustered Column Chart and multiselecting certain data on the chart. Is there a way to use like conditions as to when I hover over the card it changes color and when I select a lets say a months in the chart the card also changes Color?

[@PowerBIPark]

Unfortunately that can only happen in with buttons, or the new button slicer I'm afraid

[@cameronweston1038]

@@PowerBIPark ok ill check it out. Thank you

[@karinemelo2549]

Good work. Nice video Park !

[@PowerBIPark]

Thanks! 👍

[@gercostuij5891]

Hello, Is there also a possibility to add a goal as was the case with the 'old' KPI?

[@PowerBIPark]

Hi Gerco, with SVGs this is technically possible, but it's a lot more complex. If such a template already exists, I would like to use it too 😁 I will say however that microsoft intends to have this directly in the cards - even the SVG right now is technically a "hack"

[@ashcb77]

Great Video Mr. Park

[@PowerBIPark]

Thanks for the view

[@yordanosadigo]

Great Work ... But can we do conditional formatting on the icons ?

[@PowerBIPark]

Yes, you can - if we use SVGs, we can do some really interesting things. I plan to make a video about this, but you can see the concept in action in my previous video: kzbin.info/www/bejne/h4mwfqOXl62DiZY

[@yordanosadigo]

@PowerBIPark thank you subscribed to your channel

[@isaacdada8933]

Nice tutorial 💪 , one little bug I found - when a background image is added to the card visual after adding shadow or glow effect, the image doesn't cover the entire card any longer until you remove the effects. Meaning if you want the image to also have similar effect (shadow and glow), you have to do a little play around designing externally before importing to PowerBI.

[@PowerBIPark]

Nice find Isaac! Yeah there's definitely going to be more bugs, but I'm sure the microsoft team will figure it out 😁

[@PriyaAmar848]

Great video. Could you please share more details on the new feature- Button slicing technique “

[@PowerBIPark]

I've got a pretty detailed video about it already 😁 if you check the channel, you should see it

[@PriyaAmar848]

@@PowerBIPark sure thank you so much . I was looking for that video and suddenly your video on a new feature really touched me . Will definitely learn from it . Thank you once again for supporting new features heartfully 😊😍

[@BilalMakki-kf4dy]

can get database for this ??

[@lex9904]

Hi, thank you for this explanation! To your knowledge, is it possible to include hyperlinks within this new card visual? So you can open URLs via the visual? Thanks in advance =)

[@PowerBIPark]

This is pretty neat, and if there is an action option, it would be possible. I think right now it's not, and you would have to overlay a transparent button to get that effrct

[@sillylife13]

at 13:54 how can type and replace all Text in 1 time?

[@PowerBIPark]

I hacked microsoft! Nah jk it's Ctrl + shift + L

[@siddiqui_hira]

I'm applying for a jpg format image and when I apply background image , the jpg format shows white background, disturbing the whole box, what should I do?

[@siddiqui_hira]

please help

[@kanwals_food_hub]

I didn't get the option enabled in image portion

[@TheMisiekMisiek]

Great, really great.

[@renatopedrozo1561]

Awesome. Thanks for sharing!

[@PowerBIPark]

Thanks for watching!

[@gauravguliani358]

Excellent video buddy! Just subscribed

[@bandarth]

how did you select all gross sales and replace them at the same time? always had to copy and paste mine :(

[@PowerBIPark]

Hey, try selecting something, and the hit Ctrl + shift + L

[@bandarth]

@@PowerBIPark thank you

[@aleksvpYT]

Fantastic! Tks

[@AliAlSayer]

Does this store image on third party site which created from Kerry site as measurement?

[@PowerBIPark]

not at all, this image is stored internally inside power bi (as you upload images) The SVGs are created by the measure, so you can think of it as being stored inside the \DAX

[@danielkpkk1005]

Is it possible to rotate the card in power bi rather than I being horizontal?

[@PowerBIPark]

I'm not sure what you mean 😅

[@jonbaylis2203]

Superb, thank you.

[@ArmandoReportes]

Thanks! It looks great.

[@PowerBIPark]

Hope you like it!

[@dumisaralane]

Awesome demo, thanks! 👏🏽 ❤

[@PowerBIPark]

Thanks for watching!

[@leemeiwah]

Thanks for making it so detail and easy to understand 😊

[@PowerBIPark]

Glad it was helpful!

[@Pa3cK]

that's cool, new visual prowess to add on my tool :)

[@BISimplifier]

Can we add highest and lowest points like in Sparklines?

[@PowerBIPark]

Probably you could, but you would have to add the elements in the HTML code. Probably you need a better web designer than me 😂

[@henrifanda4784]

excellent tutorial

[@swhite4170]

13:58 How did you do that?

[@PowerBIPark]

I hacked microsoft! Nah jk it's Ctrl + shift + L

[@shalommansoor]

Has anyone encounted an issue with the table containing their measure completely disappearing when loading data from a .pbit file (template) ? I get an error on loading saying: All MEASURES This query does not have any columns with the supported data types. It will be disabled from being loaded to the model. and if i select continue, the report loads without the ALL MEASURES table and all measure in that table are gone ? This has only happened since the june update Does anyone know whats going on and how to resolve it ? PLEASE !!!

[@PowerBIPark]

So I know this is something that happens, you might need to revert to the previous version of power bi 😔

[@shalommansoor]

@@PowerBIPark how do you do that - my power BI update automatically. and where do i find the previous version ?

[@PowerBIPark]

@@shalommansoor I recommend just googling "previous power bi version - may 2023", and you should find some links 😁

[@cyriladeyemi5627]

Really great video. Any tips on the sites where you get the icons from

[@PowerBIPark]

You can find some on flaticon, it's by wanicon 😁

[@davidjosevarelagarcia7011]

Great video.

[@तारकमेहता-ढ1फ]

how to apply filter on this visual on a particular card in new updated card

[@PowerBIPark]

You can't - you would need to create a specific condition in the measure using calculate function I think

[@तारकमेहता-ढ1फ]

@@PowerBIPark I think in new card it is not possible I try again and again but filter apply on all card

[@mohamedkhafaga6043]

That's amazing Is the dataset available to download to play around with it?

[@PowerBIPark]

This is the native dataset, try opening power bi and not loading any data - you'll see the place where I load data.

[@justynasz2890]

Hi, thanks for great video. Can you help me with my spraklines? I did everything as you, but I can't see a sprakline. It seems to be there, because a number of TotalSales is a litlle bit higher than others numbers, but still as if invisible. I have AdventureWorks2019 star schema database, so my dates are from DimDate, maybe this is a problem ?

[@PowerBIPark]

So in the code, you might need to change the date value, I think in the code from Kerry's website, it's financials [date], and you would need to change that to match your data 😊

[@justynasz2890]

@@PowerBIPark yes, of course I did it, but still doesn't work :(

[@PowerBIPark]

So this might be a case of needing to change the view box. Its the part of the code that I change to remove the line at the end in the video. Try changing the last number (so it's 0 0 145 50) into something larger (0 0 145 100). This might help 😁

[@justynasz2890]

@@PowerBIPark thanks for advice, unfortunately it still doesn't work, sparkline works in a table but in a new card not. I did it on the same databse (financial), and the same problem, so it seems to be bigger issue.

[@PowerBIPark]

Did you try changing the image size outside of the code? I mean in the filter panel there should be an image pixel size

[@yoanridhopambudi3682]

Can i get this file ? For learning plis

[@ahmedshalaby9343]

That’s amazing i’d like to hear from you every pb update i hope u consider this

[@PowerBIPark]

Thanks Ahmed - I'll consider it for sure :)

[@hamedbakhtiari5094]

excellent, thanks

[@shripaddeshpande5766]

Awesome