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
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.
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" )
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.
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 ?
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 ).
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 🌹🌹
![ไปอยู่ไสมา - ช๊อปเปอร์ โตเกียวมิวสิค [ OFFICIAL MUSIC VIDEO ]](http://i.ytimg.com/vi/sWuVNbRTJbc/mqdefault.jpg)
![ง้อ (ALRIGHT) - FOURTH [ TEASER ]](http://i.ytimg.com/vi/ya6MBfo-Wvg/mqdefault.jpg)
![เบิ้ล ปทุมราช - สาวสอง ( มีมี่ของอ้าย ) ft. ตาต้า,ต้องเต [OFFICIAL MV]](http://i.ytimg.com/vi/mqlMjnP08XI/mqdefault.jpg)
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!
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
Another superb video. Excellent trick and presentation. Thank you Chandeep!!!
My pleasure !
Amazing tip Chandeep and thank you for sharing!!!!!
Always welcome
Once again Chandeep surprising us! Thank you for that sir. :)
Glad you like it!
video ending is really good
Thank you!
Thank you Chandeep sir 😍😍😍😍😍😍
Sir.. Aap yaha aye, heart wala emoji diye.. thank you so much!
An excellent idea. Thak you very much. :-)
Glad you like it!
That’s a good one. Thank you.
Glad you like it!
Love it❤
Excellent!
Thank you!
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.
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"
)
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
🙏🙏🙏🙏
Awesome sir❤
Insightful ✅☑✔
Thanks !
Hi, is this possible to resize tool tip page canvas. It was default size. Pls make vedeo on this
How to show selected value for field parameter in tool tip
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.
Are you offering any courses at Udemy If yes can you tell those list
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 🌹🌹
Chandeep, did you say Reid Evans?
Yes
Reid Havens...th-cam.com/channels/jlfQwqb-0S40XQ8seYPLSw.html