Create Dynamic Tooltips Using Field Parameter in Power BI
Вставка
- Опубліковано 22 лип 2024
- 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 UA-cam Channel Below
ua-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - Наука та технологія
This channel deserves much more 👏 amazing unique content and always to the point. Thank you for your work
Thank you for the inspiring words!!
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!
You are so welcome!
Another superb video. Excellent trick and presentation. Thank you Chandeep!!!
My pleasure !
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
Amazing tip Chandeep and thank you for sharing!!!!!
Always welcome
That’s a good one. Thank you.
Glad you like it!
An excellent idea. Thak you very much. :-)
Glad you like it!
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"
)
How to show selected value for field parameter in tool tip
Love it❤
Excellent!
Thank you!
Once again Chandeep surprising us! Thank you for that sir. :)
Glad you like it!
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.
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.
Thank you Chandeep sir 😍😍😍😍😍😍
Sir.. Aap yaha aye, heart wala emoji diye.. thank you so much!
video ending is really good
Thank you!
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.
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
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 ?
Can you please try posting this on the Power BI Community.
Thanks
@@GoodlyChandeep I had posted in Power BI community but no answer, can you please help me with it.
🙏🙏🙏🙏
Awesome sir❤
Insightful ✅☑✔
Thanks !
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 ).
Use this function Date.From(DateTime.LocalNow()) to get today's date to be applied as a filter
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 🌹🌹
Are you offering any courses at Udemy If yes can you tell those list
Chandeep, did you say Reid Evans?
Yes
Reid Havens...ua-cam.com/channels/jlfQwqb-0S40XQ8seYPLSw.html