power bi sucks so bad.. all that for a stupid date filter... Metabase man..

It is truly helpful explanation, clear, and easy to understand . Thanks!

This is awesome

This is a game changer, thank you! Super impressive on its own, even more so if the video wasn't sped up.

That is awesome 👍 thanks for sharing this

Unfortunately the solution for web.contents does not work for me. Web.Contents is not accepted. Instead it's Web.Page(Web.Contents('...")) Which is "Open as Html page (Legacy)" However, I am still unable to access Data Source Credentials and Schedule the Refresh !!!

Been cracking this one for a long time, thanks!

Hi. I'm working with API calls for Reverse Geocode. Do you have any idea how I can make it static with my data set in Google Sheet so I can use the Auto Refresh function?

Great video!! Can you please help me on how to get the "Previous Week" (last week) default slicer selection.

Great guide, easy to follow. Was able to remove the need for having two separate dashboards to give to two different demographics when the only difference was a constant line for one group vs no constant line for the other. No other differences. Thanks! 🙂

Incredible!! Cheers from Brazil!

100% exactly what I was looking for. Thanks a million!

thank you soooo much!! I've been stuck at the label issue for a week and there's no correct answer across all forum, and your video is the answer!! much appreciated!

still an amazing trick in 2024!!!

Thank you!!! Straight to the point and accurate!

Hi, i'm getting the following errors when i try to connect to the web content :unable to connect because credential type is not supported for this resource, any idea how to solve this?

Omggggggggg this is the best ever , i exactly what i want to in my report.this video really help me a lot 🎉🎉🎉🎉 thx so muchhhhhhhhhhhhh

You earn my subscription! So well-explained!

Thanks so much for this, I have been having this problem for years and thought there was no solution

very well explained!

Superb, cheers.

Fantastic. I went through so much stuff but this is a jackpot! thank you for this✌

This was perfect. Thank you so much for this. Can someone help me and tell me how I can do the past 6 months too? I am pretty new to power BI

That is wonderful approach.. is it possible to show cohort analysis by weeks instead of months. I am not finding any supporting method to calculate the same cohort by weeks.

This is brilliant! I've been stumped for weeks trying to get around the measure as slicer limitation. Amazing.

Something to add to this. The video is based on a scenario where you have the Auto Date/Time option enabled in your settings. This creates a hidden date table underpinning your date and date/time fields. If you have an actual calendar table, then you will not be able to use the same syntax. You would need to do something like this: Hierarchy level = SWITCH(TRUE(), ISINSCOPE('Calendar'[Date]), "Day", ISINSCOPE('Calendar'[Month Name]), "Month", ISINSCOPE('Calendar'[Quarter]), "Quarter", ISINSCOPE('Calendar'[Calendar Year]), "Year")

These are so unique and well executed! Thanks so much to the creators for sharing their work. It’s scary to do so in an age of rampant plagiarism. I hope everyone gets plenty of traffic and work opportunities for their efforts.

I need good wen please

Amazing trick, very helpful

How to solve it for daily basis instead of month?

When I do this it works welll, but now it is asking for a Gateway, do we need to install a gateway for this to work properly?

I want to get rate from users then want to convert into that rate . how to do ? like if choosed INR then show INR value, if choose USD then pur rate from numeric range parameter and convert into USD using given rate , not manually put into table then convert

extremely helpful and fast solution congrats!!!!

why am I getting "A circular dependency was detected" when creating the relationship?

why would order matter with isinscope? it evaluates to true when it hits it

but how will it take input from front end if I give to the user?

how to make it automatically detect the Item code and system time and datae and user email. I just want them to add comemnts and they cant edit the date time, email or item code? I have tables having relationship based on Item code?

i want upon none selected no column should get selected. How to achieve it ?

For people having an issue with the date range filter not being cleared when selecting something other than 'custom', whilst I haven't found a solution, I've found a workaround which helps. The workaround effectively warns the user if the date range in the date range is affecting their search, and if it is it shows a message asking them to clear the selection in date range slicer. The quick guide steps are: 1) Clear the selection in the date range using the 'Clear selections' button. This seems to help clear the dates. 2) Create a measure to find the min date in the Dateperiods table 3) Create a measure to check if the min date from the previous step is blank, or in my case if it falls below the minimum date in my dimensions date table. If it does return 1, else 0. 4) Create a card and put a title to warn the user to clear the date range selection, and set the text colour to to same as the background it is on. 5) On the card above put conditional formatting on the Use the measure to change the colour of the background depending on if 1 or 0. If 0 keep it at normal background colour, if 1 change to red background. Step 2 Measure (MinNewDateTableDate = MIN(DatePeriods[Date]) Step 3 Measure CHECKFLAGDatePeriods = IF(SELECTEDVALUE(DatePeriods[Type]) = "Custom", 0, IF(ISBLANK([MinNewDateTableDate]), 1, IF(CALCULATE(MIN(D_Dates[Date]), ALL(D_Dates)) <> [MinNewDateTableDate], 1, 0)))

Great video. Thanks for sharing. However, my correlation coefficient return abnormal number, same attribute in X and Y do not return 1 but 0.xx instead. Has anyone face similar situation?

Thank you! This is exactly what I am looking for! I wish PowerBI can add this feature to allow users move around these headers/Columns, it should be really simple!!

= DateTimeZone.ToText(DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -7), "yyyy-MM-dd HH:mm:ss") Can also try this based on UTC time difference

The api is no longer working. how to resolve it. Thank you

can we still find the api now (2024) in Microsoft form?

Woooowwwww. I cant believe i found this!! Thanks!

Thank you so much for sharing. I see that the hight and width are not changing for me

To export data, the limitation is 150,000 rows. Does this mean exporting data will be affected here since the table is pivoted?

To export data, the limitation is 150,000 rows. Does this mean exporting data will be affected here since the table is pivoted?

Kindly reply, if we need to replace data with fresh records however it must stay unique, what I need to write as a code.

Even after five years, this is exactly what I needed!! I read several blogs, but they were not as helpful as this video. Thank you! But a slight problem for me. My 'Product Lines'[Product Line] has over 600 items. I have filtered that list to all the items we want excluded. Which means countrows = countrows. Anyone have thoughts on resolving this?