Mastering the New Card Visual: Step-by-Step Tutorial with Reference Labels in PowerBI!

Рет қаралды 38,272

Күн бұрын

🚀 Welcome to Power BI Bro! 🚀
In this in-depth tutorial, we're diving into the latest updates in PowerBI, focusing specifically on the enhanced Card Visual with Reference Labels.💡
📊Follow along using the same file!
github.com/pow...
🔍 Video Overview:
Explore the powerful features of the new Card Visual in PowerBI and learn how to leverage Reference Labels to add an extra layer of insight to your reports. Whether you're a seasoned PowerBI user or just starting out, this step-by-step guide will help you master the art of data visualization.
📌 Key Topics Covered:
Introduction to the new Card Visual features
* Step-by-step guide to adding and customizing Reference Labels
* Practical tips for optimizing your data presentation
🎓 Who Is This For?
This tutorial is designed for data enthusiasts, analysts, and PowerBI users looking to elevate their reporting game. Whether you're creating dashboards for business, finance, or any other field, understanding the nuances of the Card Visual and Reference Labels will take your data storytelling to the next level.
🕒 Timestamps:
0:00 - Introduction
1:36 - Card Overview
4:07 - Step 1: Callout Values
7:26 - Step 2: Reference Labels
12:10 - Step 3: Detail Value Up & Down Arrows
18:43 - Step 4: Conditional Formatting
23:00 - Step 5: Final Formatting & Images
🛠️ Resources Mentioned:
Huge List of Unicode Symbols
www.vertex42.c...
📚 Additional Learning:
For more tutorials, tips, and tricks on PowerBI and data visualization, don't forget to subscribe and check out our other videos!
📣 Let's Connect:
Share your thoughts, questions, and experiences in the comments below. We love hearing from our community!
👍 Don't forget to like this video if you find it helpful and subscribe for more valuable content on mastering PowerBI and data analytics!
#PowerBI #DataVisualization #CardVisual #ReferenceLabels #Tutorial #DataAnalytics #BusinessIntelligence

Пікірлер: 89

@steveyaich8084 5 ай бұрын

What a fantastic tutorial. Great work. Looking forward to seeing more from you. Thank you!

@PowerBIBro 5 ай бұрын

Thank you!!

@G0alMachine7 7 ай бұрын

This is wonderful, I learned so much from you in this video and decided to remodel my dashboard using the new Card and reference labels using your techniques. thank you!

@PowerBIBro 7 ай бұрын

Excellent!! I’m so happy you shared!

@Gandalf1969Guy 8 ай бұрын

Amazing - thank you and well done. Happily subscribed and looking forward to more content. For all the channels out there - this video hit the sweet spot for me. The right tempo, easily understandable, digestible, applicable and as importantly for me - you actually give a damn about how it LOOKS on the page even down to bumping things around by a pixel or two and showing where and how that's done. So the end result looks as good as the dynamic content (love the dynamic headers - admittedly as excited about these new card visuals with reference labels as I am your videos :)). Keep 'em coming!

@PowerBIBro 8 ай бұрын

Thank you for the feedback! I’ll keep them coming and thanks for subscribing!

@karljolivet5991 Күн бұрын

Very in dept teaching for this visual. I also like the variable with arrow. But if the variable is 0 and I don't want a down arrow. How would I write this in the variable. Still a newbie in DAX

@PowerBIBro Күн бұрын

Thanks for your question, first step is to decide what you want instead. If blank, you can change the Dax around so the thresholds return nothing

@ibrahimhammed4176 Ай бұрын

Thanks for posting this. I gained a lot from it. I, however, observed that Units Returned, when positive, appeared in red instead of green at 2:18 and when negative, appeared in green instead of red at 5:53. I reckon there is an error in the IF construct handling the switch.

@PowerBIBro Ай бұрын

Thank you for sharing and I appreciate your feedback!

@ericaunzo717 8 ай бұрын

Instantly became a "SUB"! Great content. I will watch all your videos. I'm learning so far. Thank you.

@PowerBIBro 8 ай бұрын

Excellent thank you!!

@macshock632 16 күн бұрын

Super! Tks.

@PowerBIBro 16 күн бұрын

My pleasure! Glad you like it and thank you for sharing!

@estherling2596 6 ай бұрын

This is AMAZING!! Super awesome content!

@PowerBIBro 6 ай бұрын

Thanks so much!!

@sankhlayashraj 7 ай бұрын

You were super. Thank you for teaching this.

@PowerBIBro 7 ай бұрын

Thank you!!

@chrisa8203 5 ай бұрын

Is it possible to have 2 Details? I am tracking Sales variances to Budget and Last Year and want to show red / green formatting for each of the 2 variances.

@PowerBIBro 5 ай бұрын

Love the question! You can have multiple reference labels, but only one detail per reference label. You could solve the above by adding an additional reference label; creating a reference label for the budget and one for last year.

@RandomlyWisdom 8 ай бұрын

At 8:04 when you added reference labels, how did the background colour turn to cream automatically? Are there any settings?

@PowerBIBro 8 ай бұрын

Yep you can definitely control that. To get to the settings follow these steps. 1. Click the visual 2. Go to reference label section 3. Select "All" for the series 4. Go to background section and set background color desired

@RandomlyWisdom 8 ай бұрын

@@PowerBIBro thank you so much for detailed reply. Thanks

@PowerBIBro 8 ай бұрын

My pleasure!

@Datavoll 2 ай бұрын

Great work here 🎉

@PowerBIBro 2 ай бұрын

Thanks for your comment and glad the video was helpful!!!

@samuelecontemori4445 5 ай бұрын

Fantastic tutorial!!! I noted that I do not have the "fit" option for images on my formatting panel..am I doing something wrong?

@PowerBIBro 5 ай бұрын

Great question! There have been a few updates since this video was created. The fit selection is now a toggle found at the below location (using PBI version Feb 2024). 1. Select the card visual 2. Go to the images section of the pane 3. There is now a "fix size" toggle button. 4. Set this to off or on based on your preferences Hope this helps!

@nurzarifahsalib1753 2 ай бұрын

Hi, its me again.. lolll! May I know what version of PBI are you using cause my PBI does not have the accent bar (22:06) how do I enable it. I feel like my PBI features are very limited unlike yours.

@PowerBIBro 2 ай бұрын

Thanks for the question! In that video was using Dec 2023, however the accent bar is available in every version after that as well. To ensure you're going to the right place, it's found here. Click new card visual -> go to format section -> click the "Cards" section -> the very last item in the list is "Accent Bar"

@TomaszMalkiewicz 8 ай бұрын

Good tutorial but man... Work on your audio....😊

@PowerBIBro 8 ай бұрын

Thanks for the feedback man! I’m going to get the audio in better shape

@aartdevletter5822 Ай бұрын

Agree. I didnt follow through because of the audio - but the content actually drew me in

@sabiadut8974 7 ай бұрын

Great insight Thank you

@PowerBIBro 7 ай бұрын

My pleasure!

@mattmoore1511 6 ай бұрын

Love this. Keep it up!

@PowerBIBro 6 ай бұрын

Thank you! Will do!

@wilsoneresmas4500 2 ай бұрын

Sir, please help how to create Month Name. Thanks

@PowerBIBro 2 ай бұрын

Sure thing, check out this DAX below. It generates a calendar table, you can see how to manipulate the date in many different ways. Date = ADDCOLUMNS( CALENDARAUTO(), "Year",YEAR([Date]), "Quarter", "Q"& QUARTER([Date]), "Year Quarter", YEAR([Date])&"-"&"Q"& QUARTER([Date]), "Year Month Number", YEAR([Date])&"-"&FORMAT([Date],"mm"), "Month Year", FORMAT([Date],"mmmm")&" "&YEAR([Date]), "Quarter Year", "Q"& QUARTER([Date])&"-"&YEAR([Date]), "Month", FORMAT([Date],"mm"), "Month Abrev", FORMAT([Date],"mmm"), "Month Name", FORMAT([Date],"mmmm"), "Month Sort", FORMAT([Date],"m"), "Day", FORMAT([Date],"dd"), "Day Abrev", FORMAT([Date],"ddd"), "Day Name", FORMAT([Date],"dddd"), "Day Sort", FORMAT([Date],"w") )

@tinaflemons263 8 ай бұрын

Great explanation. Thank you

@PowerBIBro 8 ай бұрын

Glad it was helpful!

@guijeanconseil 8 ай бұрын

good topic and presentation, please continue! you need to fix the sound of your mic.

@PowerBIBro 8 ай бұрын

Thank you for the feedback, mic is now fixed for future videos!

@azharshaik21 8 ай бұрын

Count me in as a new subscriber, wish to see such amazing contents 👏

@PowerBIBro 8 ай бұрын

Thank you so much!!

@user-xu6ne3td4j 6 ай бұрын

Love the content just subscribed I want to follow along what item do I download on Github to practice using the same data set?

@PowerBIBro 6 ай бұрын

Awesome & thank you! This one one of my first videos, this visual should be nested in the file 'PBI - 20231212 - Mastering the Scatterplot.pbix'. I plan on making a new version soon!

@hamzamottali3567 4 ай бұрын

I can't find the reference lable in my sitting how can i do to disply it ?

@PowerBIBro 4 ай бұрын

Follow these steps. 1. Make sure you've selected the visual 'Card (New)' 2. View the formatting pane 3. The 5th option down is Reference Labels. ... if you pick just the Card visual it will not have these features, so make sure to use the Card (New)

@hamzamottali3567 4 ай бұрын

@@PowerBIBro I'm sure that i picked the new card

@temiloluwabanji1667 2 ай бұрын

@@hamzamottali3567I had same experience as you until I updated my version. Please update your Power BI.

@nash5 6 ай бұрын

Thanks. Helpful.

@PowerBIBro 6 ай бұрын

Glad it was helpful!

@alalsilkin 7 ай бұрын

I'm sorry if didn't follow the logiс of your particular task, but I suppose you calucated Variance % not quite correct. If I may, I think you wanted to show the difference in percentage between current and previous months. If so, you needed to take different numerator rather than just variance. Other than that it's a great video. I'm trying to utilize new cards according to it and so far I've managed to succceed in everything thanks to you! Well except arrows up and down indicators. I have Win10 and PBI Desk is a bit different, I think it might be somehow realted. thanks again very much for your work!

@alalsilkin 7 ай бұрын

I stand corrected - there is no reason behind version of PBI Desk, I managed to do everything according to the video!😄 And I'm so happy! thanks again, Power BI Bro!❣

@PowerBIBro 7 ай бұрын

I love the feedback and the comments, thank you! I also love how you're diving into the details of the variance, that's great! My intent of the Var % is a bit different and not the percentage of MoM change. In this example Var % is intended to depict what percentage the MoM variance is relative to the previous month, so the percentage of variational change vs MoM change. You are totally correct if going for MoM. Thanks for these notes!!

@albertrondon3038 6 ай бұрын

I cant see this visual pbix sample in the Github.😥

@PowerBIBro 6 ай бұрын

This one one of my first videos, this visual should be nested in the file 'PBI - 20231212 - Mastering the Scatterplot.pbix'. I plan on making a new version soon!

@user-hl9ic3ov6j 7 ай бұрын

Amazing

@user-hp1lj2im9r 6 ай бұрын

Great content. Question from here though - i have been using this with the unicode arrows as indication in my measures. But it seems like from one day to the other that now my unicode symbols arent showing up when i publish my reports .. they are replaced by "--" instead. Any ideas? Thanks!

@PowerBIBro 6 ай бұрын

Interesting, when naming the measure, as an experiment try holding ‘windows’ and ‘period’ at the same time on your keyboard. It should pop open a unichar menu. Maybe try selecting an item from that menu.

@user-hp1lj2im9r 6 ай бұрын

@@PowerBIBro doesn't work, even tried changing it to another symbol from the menu you suggested. Still the same.

@user-hp1lj2im9r 6 ай бұрын

@@PowerBIBro the measure works in a normal card, it displays correctly when published. I'm starting to wonder could it be the new cards and integration with my measure thats causing it, just a bit weird how it worked some weeks ago. I just need the new cards, so i really need to solve it😅

@PowerBIBro 6 ай бұрын

What version of PBI desktop are you using? If it’s the newer Dec update, it may have a bug. If on Dec, as an experiment try installing the Nov 2023 update and open you solution in that. I’ve had another weird bug which this process resolved.

@user-xn7wf1nf1j 6 ай бұрын

Hi. I also have the same issue after publishing my report 😔 My PBI desktop Version: 2.124.1052.0 64-bit (December 2023) But thank you for this tutorial 🥰

@crixcel8388 6 ай бұрын

How to use it while using field parameters

@PowerBIBro 6 ай бұрын

Great idea, I’ll make an additional video leveraging field parameters!

@oliversaballa2875 7 ай бұрын

Can anyone here confirm if they can still see the "Spacing" Format in the Callout Value section of the new card? :( I don't know what happen, but I could no longer see it from my end.

@PowerBIBro 7 ай бұрын

Hi I can help! Let me know if this is what you are looking for :) 1. Click the reference card 2. Go to the Reference Labels Section 3. Under "apply settings to" - select the series to be "all" 4. Scroll down to the spacing section 4. Set the space between labels and outer padding 6. Select "customize outer padding" to further customize and change the spacing.

@Tammy-o9q 15 күн бұрын

@oliversaballa2875 did you get an answer? It is also no longer visible to me either.

@Mike-wk7ut 2 ай бұрын

Where is the file to follow along?

@Mike-wk7ut 2 ай бұрын

I have downloaded every file and this one is no where?

@PowerBIBro 2 ай бұрын

Thanks for the question! This video was my first one and it was recorded prior to when I began publishing files... however it is available. For this one, you'll need to down the 'Master the Scatterplot' file, then go to the tab 'Power BI Bro' Here's the link! github.com/powerbibro/powerbibro/blob/main/PBI%20-%2020231212%20-%20Mastering%20the%20Scatterplot.pbix

@kuldar. 4 ай бұрын

Thank you sir! +1 subs

@PowerBIBro 4 ай бұрын

Excellent thank you!!

@oliversaballa2875 7 ай бұрын

HELP PLEASE - How come the "Spacing" Format under the Callout Value section is now missing in my view? I could no longer adjust the spacing between my Callout Value vs Label which I have done previously. Please advise.

@PowerBIBro 7 ай бұрын

@radhikamaheshwari4835 7 ай бұрын

@@PowerBIBro I am experiencing the same issue. We are not able to see the spacing in the call out value and not reference label section even after selecting "All". Could you please help.

@vishiousvish2832 8 ай бұрын

the formatting value of the label dont work for me, any idea ?

@PowerBIBro 8 ай бұрын

Hey! Check out the GitHub link and download the file I used in the example. See if that helps potentially show what may be going on.

@heeby89 7 ай бұрын

What's the name of that file? When I downloaded what you have on this page I didn't find a report that had all the measures that you're showing in the video@@PowerBIBro

@PowerBIBro 7 ай бұрын

Great question, it's a little confusing. Check out the template 'PBI - 20231212 - Mastering the Scatterplot'. All of my first videos should be within that report file. Let me know if something is missing!@@heeby89

@PraveenSinghLko 20 күн бұрын

This is Amazing , could you please provide datasets or Pbix File?

@PowerBIBro 20 күн бұрын

I’m glad you think it’s amazing! Yes, if you go to the GitHub URL used in my other videos, there is a file “Mastering the scatterplot”. That file should contain what you’re looking for.

@PraveenSinghLko 20 күн бұрын

@@PowerBIBro Okay Sir Thank You 🙏 so much