Видео

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?

Getting credential error

Hi, i get an error running the script. can i have some help please?

Very useful tutorial thank you so much!

Is there any way I can get ahold of the first dashboard? The link doesn't work anymore.

You save me. Thanks for share

This video was soo helpful!!! Thanks.

lifesaver. TY!

how do i append forms answer to an existing power bi table?

I have an error, why so?

They're not exactly attractive nor interactive though. Fail to see the benefit.

Excellent!! thank you!

A little late to the party here, but my visual keeps wanting to compare the current period with the next period in the interval (in the future). So I have a -100% change between June 2024 and July 2024. Any idea on how I could filter that out of the visual? I couldn't get the to work off the code, I had to add .[Date] to the date column reference in the DATEADD or PARALLELPERIOD code

I want to show both, the values and percentage! Any solution?

Thank you so so so so so much!

Thanks for your sharing. Btw can ad share about how to create text "Custom selection disabled" on the top of the time-range slicer, please?

thanks for sharing. BTW can ad share how to create text "Choose a custom date range" in the top of the time range slicer?

I've attempted this method but the cannot access data view to sort as I'm getting the error "This table cannot be shown because it is not in import mode". My main table is direct query to SQL server. Any work arounds?

Thanks for this wonderful Explanation, What if, i selected custom, then i change start and end date, and again i selected last Qtr, will report get filtered ? scenario, date range is from jan 2023 to jan 2024, i selected Custom, and changed Start Date to March 2023 and end date to April 2023, now if i select Last Qtr as option , i.e. Oct2023, Nov 2023 and Dec 2023, will report gets filtered ? or it will show blank in report ?

BEST POWERBI RUclips CHANNEL, PLEASE BE MORE ACTIVE

THANK YOU 🤟

It's not getting connected

How did you get dynamic heading change on custom date slicer?