A CARD VISUAL you haven’t SEEN before | MULTIPLE KPIs with line breaks ON HOVER in Power BI

[@paplight]

this has to be one of the most helpful power bi channel, keep the good work.

[@Transformita]

Your Power BI content is so unique in terms of what it teaches. I'm always amazed by what you come up and without a doubt one of the/if not most powerful Power BI content creators. Honestly stunned with how you even come up with this, amazing!!!!!

[@antique-bs8bb]

Brilliant as ever - and I love the way you race through the presentation. Gives us the option to follow through with stop and starting while copying every actions, or just to listen through a great vies (no need to adjust playback speed!) 1 thing you might have added - if you group both card and button using the selection pane, it becomes possible to move both around the screen together.

[@mehdihammadi6145]

And one more. Even if the implementation is not easy, the method is very well described and it remains only to follow the instructions to the letter. Thanks Bas

[@rbs6742]

The meticulous, talented and genius Power BI Bas, thank you for thinking and sharing these nice things with us.

[@ikaroskontaxopoulos]

You are a gentleman and a scholar. Really helpful!

[@the.activist.nightingale]

AMAZING GUY AMAZING ! I used to hate PBI with all my heart but you got me reconciled with it thank you :)

[@alicedwonderland7733]

This provided me at least two ideas to implement: hover over a button to see an explanation text and trying the FORMAT thing within a SWITCH function. Thank you, Bas!!

[@HowtoPowerBI]

great to hear!!! have fun implementing 😄

[@cammac57]

What an insanely complicated work around! Awesome work but I hope they implement some of this functionality with built in options.

[@HowtoPowerBI]

I hope so too! 😄 maybe they figure after watching this video

[@edwinmv1610]

amazing what a little extra effort can do! Thank you Bart, i'll use this in every project from now on..

[@samstudiod5247]

What an angel! You save my broken head!

[@jecwonch]

Dude. You’re a genius.

[@Lotaristo]

There is another method that i used - i created a tooltip page with data that i need and used it as tooltip for card, it works fine. And it seems quite right, but there is at least one scenario when it won't work - it's when we use non-standard visualization without tooltip implementation, and there your solution should work. Also, i really like Card with States visual by OKViz - it's really quite powerful card, and there is a dynamic template which activated only with license - but the thing is that you can obtain license for totally free, so this functionality also may work. Nevertheless nice video, i'll try to keep this thing in mind and try to implement it.

[@HowtoPowerBI]

:) sounds good, im a fan of native visuals as many organizations forbid custom visuals but i will check it out!

[@datawhipper]

Might need to watch this about 3 times before I grab it. Thanks for the wonderful tips.

[@HowtoPowerBI]

aaaah that's why the views are going up haha 😄😉 thx Abduljelil

[@Romulo1967]

Just what I was looking for... Thank you!

[@eduardpartenie3033]

All your videos are extremely impressive, I subscribed long ago, you deserve to have more subscribers, but I suppose this is quite a niche channel. Amazing work and thank you for all your examples!

[@MarceloDanielCapra]

Thank you very much Bas for your innovations, they make the boards have magic, keep up the good work, greetings

[@HowtoPowerBI]

that's awesome thx for watching Marcelo! 😎👊

[@adityapuro5654]

Hey! If there would have been one more like button, i would have tapped it just for the beard that you have! Keep up the insightful work, man!

[@HowtoPowerBI]

Haha 😂 thanks a lot, Took years for the beard so I really appreciate it!

[@brianjulius6401]

Solid gold. So many great techniques laid out in this video. I've been using Unichar (10) for a while, but didn't know about the empty space insertion technique. One question - mousing over cards is not a standard behavior. Have you thought about the ways you would provide visual cues to the user to do so in order for them to see the great "on hover" effect you've created here?

[@Akshita9614]

WOW!!!... mind boggling tricks..Hats off to you sir.

[@HowtoPowerBI]

Thanks Anju 😀

[@sugpie]

Stumbled upon this video today! Excellent content, rendering style and presentation! Thank you so much!

[@HowtoPowerBI]

so nice to hear - thx for watching Nita

[@tinaflemons263]

You are a BOSS. you come up with such amazing techniques

[@ricardorobles6874]

This is a very cool feature I am trying to use, however I'm getting stuck on inserting the new measure to the button. When I try to format the "On Hover" text to display the measure the "Based on field" function won't recognize the new measure as a valid field. I'm using "SUMX" function for the measure...any tips?

[@lightbult]

Can someone explain why the code would still require the "&"? My understanding is that the empty character is creating the space between the words and numbers resulting in numbers getting close to the right edge of the card which forces the next word to start on a new line.

[@608er]

Great content! You’re videos are outstanding

[@lucasmendoncaoficial]

you are the best man!!! Brazil appreciated!!

[@udusegbe]

Awesome trick / tip! Actually, came in handy on a request precisely on this topic - visually explain the numbers! Thanks Bas 👍👏

[@HowtoPowerBI]

oh that's great to hear! haha happy I timed it well 😄😉

[@AJM2183]

Legend. Enough said.

[@HowtoPowerBI]

thank you! 😀

[@PedroAnacletoOficial]

This is beyond on all levels, so stunning!!! Thank you so much, man!

[@HowtoPowerBI]

so nice to hear - thx for watching again Pepe!!! 😀

[@cemyeten]

Oh man! This is great! Thanks.

[@CrossSo]

Your ideas are genius!

[@HowtoPowerBI]

Glad you think so CrossSo! thanks :)

[@keagankemp6275]

Once again the Bas masterclass, thanks for sharing your brilliance appreciate it

[@HowtoPowerBI]

thank you so much for nice words Keagan and for watching again!

[@adelawilliams2260]

Just wow and thank you!!!!

[@sujaynsetty]

Good as usual, thanks for the innovative ideas. Just a thought why cant we use two KPI we can instead of the button with on hover option then we may reduce the formatting

[@benjaminpappoe9680]

This channel is so useful, I will be sleeping here ❤️

[@HowtoPowerBI]

Hahahah made my day Ben! Are you still here?! ;)

[@rafaferr4254]

This video was super helpful, cheers man!! I wanted to ask, what about line breaks in a button's tooltip? For example I have an info button superposed to a table, and I want that when hovering over the info button, the tooltip shows the definition of each column's header like: Column 1: definition of column 1, which is very long. Column 2: definition of column 2, which is very short. Column 3: definition of column 3, which has medium length. I have tried many different things that work for other types of visuals but do not work for a button's tooltip!! Would you have any advice for this? I have looked through your other videos but I haven't found something that could help me on this particular issue. Thanks a lot!!

[@joarvatnaland6904]

How would PowerBI interpret the newline character " " in a string?

[@ianaugusto1163]

Idéia fantástica, nunca tinha imaginado transformar um botão em card. Obrigado por compartilhar.

[@HowtoPowerBI]

obrigada Ian!

[@dannyhometown]

Love this tips Thanks for sharing, mate.

[@HowtoPowerBI]

thank you Danny!!! 😀

[@prajaktarajendra7335]

thanx you are doing really great job!!!GBU

[@prasadk5082]

Absolutely awesome 👍👍👍👍

[@marekbudzicz7827]

What I can do when I use filters is the number that is displayed has a different value and the whole KPI crashes and does not look aesthetically pleasing

[@JoelNove]

Hello! Where did you incorporate the KPI_NumberSpacesRight? Was it cut off on the video? Thanks!

[@HowtoPowerBI]

Hi Joel, maybe easiest to download the file (see link in the description)

[@JoelNove]

@@HowtoPowerBI cool thanks!

[@honorengonobeyala9215]

Hello, please can you give us the link for the website to have that blank space? Thanks

[@HowtoPowerBI]

emptycharacter.com

[@chriscosta7584]

have they made the update yet???

[@PedroCabraldaCamara]

Amazing Bas. Thank you so much

[@HowtoPowerBI]

😊😀thx Pedro

[@peterbogdanovich4043]

Defintly very interesting. But in a real world scenario you gonna have to decide either to go thru so much for a bit of eye candy, or spend the time that you don’t have to meet your deadline? Your call! Nevertheless; excellent job!

[@HowtoPowerBI]

I have too much time so ended up with this eye candy video 😂

[@kennethstephani692]

Great video!

[@msoffice6037]

Strangely enough I don't have options to use metrics in conditional formatting, only columns. How to change it?

[@HowtoPowerBI]

you can only use measures that are correctly set up for conditional formatting - so measures that return a certain color or number given a limited number of outcomes ( and of course they shouldn't contain an error :) )

[@sricharang9537]

Great video Bas! Love your attention to detail 👍

[@SedatOnat]

Brilliant !!!

[@HowtoPowerBI]

Thanks Sedat!

[@flyingwingscreations1986]

what is the website to copy the space symbols

[@HowtoPowerBI]

emptycharacter.com/

[@StoianDstefan]

nice!

[@jeffersondourado1858]

Amazing!

[@kairoh6886]

Tooltip page ?

[@sharkillsbear]

Very cool! Hoping I can find a use for this one.

[@HowtoPowerBI]

thx Adam!! 😅 now you have to check all your pbi reports to see if there is a card visual you can apply it to haha 😂😁

[@sharkillsbear]

@@HowtoPowerBI I've actually been down that rabbit hole since watching! :D It's such a nice, simple presentation solution that it will work well for some of my upper management reporting where leaders don't love lots of charts and graphs.

[@liamlindy]

Can this not be done in the tooltip??

[@HowtoPowerBI]

would be an alternative, different ux though as the tooltip doesn't exactly overlap

[@ericet19]

Excellent, thank you

[@HowtoPowerBI]

thank you for watching!!! 😀

[@rodriguesfernand]

Thanks!

[@HowtoPowerBI]

Thank you so much Fernando for supporting the channel! I really appreciate it a lot!! 😊😀

[@vladoblazicek9165]

I use UNICHAR(10) to separate lines in card visual

[@HowtoPowerBI]

👍

[@eagillum]

15:55- end result

[@brunogazoli]

How to make spacing on rows in the matrix?

[@HowtoPowerBI]

not sure what you mean / what effect you are going for - you already tried line breaks / spaces ?

[@Sideshowgaz5779]

Amazing content. Another way where you are again filling the gap that Microsoft have left in their tools.

[@ruslangusiev7677]

Amazing!🙃

[@HowtoPowerBI]

Thanks! 😄

[@theenlightened1s]

emptycharacter is not working anymore after the latest update to Power BI

[@damionc]

I love the idea and ingenuity in this but why not just create a custom tooltip. But I love the idea it's genius.

[@HowtoPowerBI]

tooltip is also ok, ux is just a bit different

[@marekklucka316]

I know this is pretty nice solution, but wouldn't it be easier to create a tooltip page with a table?

[@HowtoPowerBI]

Definitely easier haha - ux is a bit different though .. u have to check for yourself if its worth it

[@lucasshipsides1510]

interesting idea, but i don't think it's easier or better than making a custom tooltip.

[@HowtoPowerBI]

aaah u never know, maybe it will still come in handy some day 😉 .. did for me

[@supersayan9888]

I am curious, are you Dutch?

[@haasii]

when this just be something it can do? lol i feel like so many of your videos involves this space char

[@spen2431]

👍💥👍💥

[@alexisbjj7]

Thanks!

[@HowtoPowerBI]

thank YOU for your support, Alexis! :)