A CARD VISUAL you haven’t SEEN before | MULTIPLE KPIs with line breaks ON HOVER in Power BI
Vložit
- čas přidán 1. 08. 2024
- Adding a hover effect to a KPI card is a very powerful way to provide more context to your KPIs without taking space on your reports. This technique can set your report miles apart from other designs! I also provide a solution to add line breaks even if there is no word wrap or source spacing options for the element to which you are adding text. Try it out and let me know what you think. Enjoy the video and subscribe for more Power BI tricks!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:44 Showing a different text when hovering over a card
03:04 Everything you need to know about line breaks and spaces
06:56 The line break problem for buttons and the empty space fix
08:17 Adding line breaks on a button
14:07 Aligning the KPI values on the card
16:06 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - Věda a technologie
this has to be one of the most helpful power bi channel, keep the good work.
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!!!!!
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.
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
You are a gentleman and a scholar. Really helpful!
The meticulous, talented and genius Power BI Bas, thank you for thinking and sharing these nice things with us.
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!
amazing what a little extra effort can do! Thank you Bart, i'll use this in every project from now on..
Just what I was looking for... Thank you!
AMAZING GUY AMAZING ! I used to hate PBI with all my heart but you got me reconciled with it thank you :)
You are a BOSS. you come up with such amazing techniques
Stumbled upon this video today! Excellent content, rendering style and presentation! Thank you so much!
so nice to hear - thx for watching Nita
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!!
great to hear!!! have fun implementing 😄
This is beyond on all levels, so stunning!!! Thank you so much, man!
so nice to hear - thx for watching again Pepe!!! 😀
Great content! You’re videos are outstanding
Just wow and thank you!!!!
Dude. You’re a genius.
Might need to watch this about 3 times before I grab it. Thanks for the wonderful tips.
aaaah that's why the views are going up haha 😄😉 thx Abduljelil
Oh man! This is great! Thanks.
you are the best man!!! Brazil appreciated!!
What an angel! You save my broken head!
Awesome trick / tip! Actually, came in handy on a request precisely on this topic - visually explain the numbers! Thanks Bas 👍👏
oh that's great to hear! haha happy I timed it well 😄😉
Thank you very much Bas for your innovations, they make the boards have magic, keep up the good work, greetings
that's awesome thx for watching Marcelo! 😎👊
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?
Once again the Bas masterclass, thanks for sharing your brilliance appreciate it
thank you so much for nice words Keagan and for watching again!
thanx you are doing really great job!!!GBU
WOW!!!... mind boggling tricks..Hats off to you sir.
Thanks Anju 😀
What an insanely complicated work around! Awesome work but I hope they implement some of this functionality with built in options.
I hope so too! 😄 maybe they figure after watching this video
Great video!
Absolutely awesome 👍👍👍👍
Love this tips Thanks for sharing, mate.
thank you Danny!!! 😀
Your ideas are genius!
Glad you think so CrossSo! thanks :)
Idéia fantástica, nunca tinha imaginado transformar um botão em card. Obrigado por compartilhar.
obrigada Ian!
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
Amazing Bas. Thank you so much
😊😀thx Pedro
Amazing!
Brilliant !!!
Thanks Sedat!
Excellent, thank you
thank you for watching!!! 😀
Legend. Enough said.
thank you! 😀
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!
Haha 😂 thanks a lot, Took years for the beard so I really appreciate it!
Thanks!
Thank you so much Fernando for supporting the channel! I really appreciate it a lot!! 😊😀
Very cool! Hoping I can find a use for this one.
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 😂😁
@@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.
nice!
Great video Bas! Love your attention to detail 👍
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!!
This channel is so useful, I will be sleeping here ❤️
Hahahah made my day Ben! Are you still here?! ;)
Amazing!🙃
Thanks! 😄
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.
:) sounds good, im a fan of native visuals as many organizations forbid custom visuals but i will check it out!
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?
How would PowerBI interpret the newline character "
" in a string?
Amazing content. Another way where you are again filling the gap that Microsoft have left in their tools.
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
Hello, please can you give us the link for the website to have that blank space? Thanks
emptycharacter.com
15:55- end result
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!
I have too much time so ended up with this eye candy video 😂
have they made the update yet???
Hello! Where did you incorporate the KPI_NumberSpacesRight? Was it cut off on the video? Thanks!
Hi Joel, maybe easiest to download the file (see link in the description)
@@HowtoPowerBI cool thanks!
I use UNICHAR(10) to separate lines in card visual
👍
Strangely enough I don't have options to use metrics in conditional formatting, only columns. How to change it?
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 :) )
How to make spacing on rows in the matrix?
not sure what you mean / what effect you are going for - you already tried line breaks / spaces ?
Tooltip page ?
what is the website to copy the space symbols
emptycharacter.com/
Can this not be done in the tooltip??
would be an alternative, different ux though as the tooltip doesn't exactly overlap
I love the idea and ingenuity in this but why not just create a custom tooltip. But I love the idea it's genius.
tooltip is also ok, ux is just a bit different
when this just be something it can do? lol i feel like so many of your videos involves this space char
emptycharacter is not working anymore after the latest update to Power BI
👍💥👍💥
I am curious, are you Dutch?
I know this is pretty nice solution, but wouldn't it be easier to create a tooltip page with a table?
Definitely easier haha - ux is a bit different though .. u have to check for yourself if its worth it
interesting idea, but i don't think it's easier or better than making a custom tooltip.
aaah u never know, maybe it will still come in handy some day 😉 .. did for me
Thanks!
thank YOU for your support, Alexis! :)