Create Dynamic Tooltips Using Field Parameter in Power BI

Рет қаралды 21,113

Күн бұрын

In this video, I'll share an interesting technique to create Dynamic Tooltips using Field Parameter in Power BI.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
1:03 Introduction to the Tooltip
0:59 Creating the Tooltip Page
1:53 Creating the Dynamic Slicer
4:42 Applying Dynamic Colors to the Tooltips
6:24 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall KZfaq Channel Below
kzfaq.info/love/GQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

Пікірлер: 42

@mohamednour4874 Жыл бұрын

This channel deserves much more 👏 amazing unique content and always to the point. Thank you for your work

@GoodlyChandeep Жыл бұрын

Thank you for the inspiring words!!

@rauljimenez5485 Жыл бұрын

Great video as always and great use of Gestalt's principals to convey information to the end user by changing colors!! Thank you very much!

@GoodlyChandeep Жыл бұрын

You are so welcome!

@IvanCortinas_ES Жыл бұрын

Another superb video. Excellent trick and presentation. Thank you Chandeep!!!

@GoodlyChandeep Жыл бұрын

My pleasure !

@kabeerkhan5875 Жыл бұрын

Love it❤

@Soulenergy31 Жыл бұрын

Amazing tip Chandeep and thank you for sharing!!!!!

@GoodlyChandeep Жыл бұрын

Always welcome

@mnowako Жыл бұрын

That’s a good one. Thank you.

@GoodlyChandeep Жыл бұрын

Glad you like it!

@gopichand5717 Жыл бұрын

Hi chandu This is awesome I have used field parameters fields from calender table - year month week When we select One option after other We have sorting issue in axis

@alexrosen8762 Жыл бұрын

Excellent!

@GoodlyChandeep Жыл бұрын

Thank you!

@fajnefajne4339 Жыл бұрын

An excellent idea. Thak you very much. :-)

@GoodlyChandeep Жыл бұрын

Glad you like it!

@juanignacioXI Жыл бұрын

Once again Chandeep surprising us! Thank you for that sir. :)

@GoodlyChandeep Жыл бұрын

Glad you like it!

@Piyush.A Жыл бұрын

Thank you Chandeep sir 😍😍😍😍😍😍

@GoodlyChandeep Жыл бұрын

Sir.. Aap yaha aye, heart wala emoji diye.. thank you so much!

@aldasaridhanunjayudu8121 Жыл бұрын

video ending is really good

@GoodlyChandeep Жыл бұрын

Thank you!

@perfectionist6624 Жыл бұрын

Awesome sir❤

@perfectionist6624 Жыл бұрын

Insightful ✅☑✔

@GoodlyChandeep Жыл бұрын

Thanks !

@abhijeetshetye8785 Жыл бұрын

Great and very helpful video. Thank you. But one problem in parameter function, I try to switch column based on parameter slicer but that slicer keeps blanks. Do you know any way to skip blank and show only those rows which have data. It will very helpful. Thank you in advance.

@GoodlyChandeep Жыл бұрын

The blanks are shown typically when your fact tables have values that are missing in the dimension tables. You can either fix that or apply a NOT Blank filter as a patchy solution.

@prewpow3115 Жыл бұрын

Great video! But I am having an issue...The SWITCH function is not working properly for me. It changes both filters to green, but I also have the black color for the other field. Could you tell me where the problem could be? ColorChange = SWITCH( TRUE(), ISFILTERED(DimProduct[EnglishProductName]),"Green", ISFILTERED(DimProduct[ModelName]),"Black" )

@narendrababu2287 Жыл бұрын

Hey chandeep, There will be some columns where I can directly use the column reference in values section or in a measure where don't want any aggregation. I just want to pick the value from from the the same row depending on a selection. For example example: if(selectedvalue(col1)="me",col2,blank()) I want to achieve the above example shown but in true case we cannot use column reference directly, we need to use aggregation or a measure. I don't want to use aggregation or measure, I just need to get the result just from the selection. So, how can I achieve this. Please do a video on this topic. It's a request.

@GoodlyChandeep Жыл бұрын

To do this, you'll have to create a context within your measure where the column value comes down to a single value. Then it should work

@trustnonor5139 Жыл бұрын

🙏🙏🙏🙏

@sathishkumar-yh9mx Жыл бұрын

Hello, can you upload a video on explaining time intelligence slicers where we have the MTD, YTD, PYTD on the slicers and we can slice them to have the desired output in a card visual. I am stuck with that. Can you please explain it with a video ?

@GoodlyChandeep Жыл бұрын

Can you please try posting this on the Power BI Community. Thanks

@sathishkumar-yh9mx Жыл бұрын

@@GoodlyChandeep I had posted in Power BI community but no answer, can you please help me with it.

@prasadroyal6101 Жыл бұрын

Hi I'm facing the one issue could you please explain it. My data source is Sql live connection i want to dynamic filter in the current date [today's date] (No need addition the calendar table please explain it ).

@GoodlyChandeep Жыл бұрын

Use this function Date.From(DateTime.LocalNow()) to get today's date to be applied as a filter

@user-so1qt9vn1j 8 ай бұрын

How to show selected value for field parameter in tool tip

@mohammadafsari4686 Жыл бұрын

Hi Thank you , question i have pms file i want to know is there any way to excel calculate by own and find 3rd date between start and finish date with formula and gives best match date between 2 start and finish date , it's example that can expand for 1000 tasks Imagine i have 3 tasks with 5 days duration start is 1/1/22 and finish is 1/12/22 so first task start 1 day and 3rd task start 1/7/22 now I want excel calculate and find best date between in 2 tasks that must be 1/4/22 Now is there anyway excel calculate and find this date, this is can use for 1000 tasks more or less that I need to find it 1000000 tnx if you help me 🌹🌹🌹🌹 Thank you 🌹🌹