Create your own KPI SPARKLINE using DEFAULT VISUALS in Power BI // Beginners Guide to Power BI

Подписаться 44 тыс.

Просмотров 10 тыс.

50% 1

In this video we're going to look at how you can create a KPI sparkline card in Power BI which shows you your current totals, trends, highest and lowest, and variance. All without using custom visuals
🕓 TIMESTAMPS
0:00 - Intro
02:04 - Demo
05:35 - Creating DAX measures
11:28 - Formatting the visuals
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: fernan@solutionsabroad.co.uk
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@Soulenergy31 10 месяцев назад

Thanks for this Gold! 5:44 Titlle 8:24 subtitle measure 9:17 high and lowest 13:11 adding subtitle 13:44 Window key + . for symbols 14:34 change color based on calculation

@hellmutmatheus2626 11 месяцев назад

thats a hell of a tutorial, so much worth information compacted in a assetive video. Instant subbed. Thanks for the video man!!

@jennytrevino8066 Год назад

Wow, you are so amazing ! Thanks for the tutorials 😊

@stanisitendempombo2598 11 месяцев назад

Thanks FERNAN for this tutorial very instructive and simple explanations ❤

@derpole5143 11 месяцев назад

Insane video, thank you so much.

@pavelandreev6023 Год назад

Greate and clear! Tnx

@pthapa55 Год назад

That is cool. Thanks for the post.

@karinamatvejeva3164 Год назад

🔥🔥🔥 Thank You!

@nataliefedorenko 10 месяцев назад

Cooool! Thanks 😊

@subramanianramasamy2959 Год назад

that's a cool trick sir!

@billionairemindset7192 Год назад

Thank you farhan

@aishwaryapattnaik3082 Год назад

Can you create a video on how to create a Fiscal Year Calendar Table lets say from OrderDate column from Fact Table and the other required columns..I already have a calendar table

@pabeader1941 3 месяца назад

I can't believe they still haven't added the ability to use a function to change the markers. Love the hack but come on PMs let's get this corrected!

@jayxpea Год назад

when I try to add the title and subtitle it won't let me. It just remains blank after selection with a red box around it, Any ideas?

@slactran 5 месяцев назад

same here. Have you found a solution? Thanks

@maksimkisliak4782 Месяц назад

change the title measure data type onto Text

@Alepagio95 Год назад

You forgot the Trend line 😅

@ABIDHUSSAIN-qh4hx 11 месяцев назад

Hello, Can i get help on this Thanks ? Switch is only reading first line. If I change the order of the line and ,[Total Sales]=_highest,"green" then it will change to green so basically showing only one colour. Here is the code Highlights = VAR _table= SUMMARIZE( ALLSELECTED('Order Details') , Orders[OrderDate].[Month], "Sales", [Total Sales] ) VAR _highest= MAXX(_table,[Total Sales]) VAR _lowest = MINX(_table,[Total Sales]) RETURN SWITCH( TRUE() ,[Total Sales]=_lowest,"red" ,[Total Sales]=_highest,"green" , "#FFFFFF00k" )