How to create STUNNING multicards in Power BI with a little bit of DAX
Vložit
- čas přidán 2. 03. 2022
- In this video I am going to show you how, with a little bit of DAX, you can create stunning multicards.
Emoji wesite:
unicode-table.com/
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10
Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Nice!!! Thanks! Just a little tip: instead of [" "&"Company name"] one can use [" Company name"] 😀
Amazing. I Love it.
Don’t care if you haven’t posted a video for a while. It makes me happier hearing that you take care of yourself.
We still have so many of your great videos to watch 👊🏻. 💪🏾
Thanks, it is hard to find meaning in making a video with everything that is going on :(
Very creative. This sort of solves the problem with the missing "form" visual. I usually solve it by creating a matrix, dropping everything into the Measure pane, and telling it to show values in rows. And then I place "----------------" in the columns to make them all appear on one line. This looks much cleaner and better than my method. More laborious but much cleaner - perfect for a perfectionist :) Thanks!
What an awesome job!!! I'll apply this in my multi row cards.
Big thanks!!!!
Te amo!! I've never thought to use that Excel/CSV old trick here WITH DAX! ❤️❤️
Thank you so much Ruth... your videos are always so helpful... I love your backdrop its beautiful. This dropped in my recommended videos, so I watched and saved to use one day.. Looking currently for how I make my cards display the results based on end user selectioning slicers and/or the data points. Wish me luck.
You will be fine but just in case: good luck!!
Wishing you, your friends, and your family safe and well at these crazy times globally. Thx for making this educational video
Same to you , truly sad days 💔
I'm really thankful to for this and many more video, and I've implemented a lot in my power Bi dashboard & shared your content among our collogues , Please keep up the excellent work.
Thanks for the feedback!!
This is so useful and really improves the look of a dashboard! Thank you for sharing!
Glad you liked it!
Thank you Ruth! This was a great tip, definitely going to use this. You're the best!😊
Thanks Bart, you too!
This is super helpful, going to spice up the aesthetics of the visuals. Thanks so much
Go, go!!
Really creative. I see there's a repeat function (like in Excel). Perhaps on row 5 you could have REPT(UNICHAR(127),3) instead - slightly shorter.
Ahh, certainly !
I thought the same
Loved the in scenes transitions! good job !!
🎉
Great video! Thanks Ruth!
Simple and effective! Thanks Ruth
Pleasure Roberto!
Nice and simple one Ruth
thanks
Thank You!
Very nice way of using multicards and making them look good. Thanks for sharing this tip :)
Pleasure :)
thank you this is really help me 😍
You're amazing!! Thank you! :)
You have exceeded the expectation once again. 😃 Glad to be your pupil.
And thanks for watching ;)
Great idea! I didn’t think to do
It in this way!
Gracias
Gracias Pilar!
Thanks Ruth, you make me look clever.
I think you are ;)
Cool technique Ruth! Thanks for demonstrating. Thumbs up!!
🎉🎉
Wow! Such a neat way to create custom cards
Thanks Vida!
Thanks for sharing
love your creativity !!
Thank you 😊
Love it ....
Very helpful!
Can you please tell me if we can make the column names bold?
Using matrix to create a visual that is similar to multi-row cards is simply genius!
Thank you!
Cool! Thanks Ruth!
At your service!
Great video
Amazing video Ruth
Hey there, hope all is well!
Thanks for another great video. I was wondering if it's possible to make it multiple lines.
It seems this solution only works for one record, I mean, once one item is selected.
So cool Trick, really loved it. Thanks
My pleasure :)
Amazing! Could this be used to create a "current selections" box to show what filters are currently applied?
Sure! But you might want to use something like this instead:
www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
Amazing Video as always! Trying to see how i can pull data that i have already unpivoted to this new innovative approach...
Music to my ears!
It’s a really nice method to improve on the current limitations of multi row cards. I can think of quite a few scenarios that it can be applied. Just wish that almost every way of making powerbi look remotely good didn’t involve hacking together tons of DAX.
Can you imagine trying to use this as a standardised display of different combinations of fields across multiple reports on top of an enterprise data set? What a nightmare to manage..
I wonder if there’s a way to make layout into standard reusable measures?
MS need to start putting some serious work into improving the visuals,because out of the box they’re looking a little dated now.
Completely agree on everything you said and hopefully they will act soon :(
Love it!!! ❣️❣️💕
🎉🎉
This is perfect for what I want to do! Thank you! But now to my next problem. My data has percent value with 2 decimals. (13.64%).
But when I follow your method, the values are formatted and displayed as decimals (0.1364)
Jaw dropping! I love it Ruth :)
Thanks Ewa :)
Extremely creative!💪
When 1 value is an error? does it possible to show others?
brilliant!
😃
Amazing...
😃
Amazingly insane 👌👌
👏👏👏
Super cool Curbal, any hacks to get the country flags, they seem to be uff 32 and not available through this method
Nice Ruth I love you
Hi hope you are doing well. I have two questions. 1. Have you uploaded any video related to setting Goals & KPIs? If yes please share the link with me as I want to learn the same. 2. Regarding managing alerts on Dashboard is there any options through which I can set a general alert? For example in my Department there are various processes related to staff benefits i.e. processing of loans, reimbursements and final settlement. Each process has an agreed Turnaround Time (TAT) I want to set alert so that if any staff's request exceeds the agreed TAT then Power BI should highlight those records for me on my Dashboard alert so that I can instruct my staff or ask them the reason for delay in processing of staff request. Many thanks in advance for your usual help.
mine doesnt show in rows or in vertical, what should I do? I did shift enter to get to the next line in DAX
Excellent solution to creating a next level multicard! I've tried this and the Unichar(10) isn't causing the next line of text to be on the next line, it remains on the same line. Through research (aka Google) some sites are stating to turn on Word Wrap, however that option isn't available for multi-row cards. How are you able to get yours to move to the next line with the Unchar(10)?
I put the measure on a table not a multi card :)
This is great. How can we make any value bold or color changing ex Germany make it Bold and different color
You can format the entire column bold the normal way, to format individual fields is a bit harder
@@CurbalEN thanks for the quick response but this is going to solve many problem. Could you please do some video on around this or any suggestions
Try with the smart narrative visual:
m.czcams.com/video/0pcTpIC6uFk/video.html
If we have multiple cities then how to implement I was trying the same but when I select the customer name from the filter I am not getting the Country Name and Region Name , Maybe one customer has multiple regions and cities and country as well, please see the below dax and suggest some ideas and Thanks again for this wonderful video..:)
Column2 =
SELECTEDVALUE(Customer_Data[Customer Names])&UNICHAR(10)&
UNICHAR(10)&
SELECTEDVALUE(Regions_Table[Country])&UNICHAR(10)&
SELECTEDVALUE(Regions_Table[City])&UNICHAR(10)
Can we add calculated measures in this visual
Yes
How to handle multi-line rows from selectedvalue function ?
How to use conditions in the details column??
Hi I have doubt. Second line is not coming in my new measure. How do I can
Hi Ruth, what is the unicode for the "person" contact name emoji you're using? I can't find the exact one you've used.
I don’t know the number, but I searched for user instead of person :)
UNICHAR(10) IS NOT WORKING AS LINE BREAK. dO YOU HAVE ANY OTHER OPTION INSTEAD?
❤
❤️
When iam using measure in it i got the decimal number
Can anyone help me please to solve this proble
👏👏👏👏🤗
🎉🎉
Hey ! I've tried this method, but unfortunately UNICHAR(10) does not seem to skip any line... I've read online I need to activate a word wrap option, but since the UI change, I cannot find any relevant screenshot or indications as to where this option may be located? Could anyone tell me?
Have you tried the search box to find the word wrap?
@@CurbalEN Hi, thanks a lot for your reply. I've tried "Word", "Wrap" and "Word Wrap". To no avail. I can only find the word wrap option for my measure Title, but that's not what I'm after in this case... So right now I'm using a regular card, but it's not looking as neat and aligned as your multirow card :(
It is under Values> Text wrap
It's a creative workaround for formating cards, but there is a point that was not touched in this video: Using a table or matrix will add ugly column headers written like "column name" and "column 2_" that Power BI does not allow to disable and you will need another workaround like changing font color or rename the column with non printable characters to make them invisible and hide.
You can either hide them or give them proper names. Both will work :)
`UNICHAR(127)` doesn't work on iPhones, it has zero width. No-Break Space `UNICHAR(160)` does work and on desktop. This is the same character that is used in HTML tables for force the renderer to draw the cell outline for "empty" cells, so is widely supported.
As my list was quite long, creating and using these two DAX variables helped the reliability of my expression
VAR indent = UNICHAR(160) & UNICHAR(160) & UNICHAR(160)
VAR nl = UNICHAR(10)
Thanks!
Thanks for sharing this tip. I've tried, but the text doesn't go as column, instead they all appear on one row. Any idea? Below is the code for the new column.
MultiCard =
UNICHAR(128188) & " " & "Client ID" & UNICHAR(10) &
"______" & UNICHAR(10) &
UNICHAR(128681) & "Client Name" & UNICHAR(10) &
"______" & UNICHAR(10) &
UNICHAR(127) & "Branch" & UNICHAR(10)
similar experience, i dont know why people are exited, it doesnt work or some option should be place and it is not specify in the video
use the table visual