SMART AXIS Magic | Let Power BI Choose the OPTIMAL Period

Outstanding 🔥

Hi Bus, thank you very much for your videos it’s really helpful
I have one query, that how we can select dynamic and static date on the selection of slicer,
Example I have one slicer having value (year, month,quarter and date ) and second slicer ( dynamic and static)
If I select dynamic from second slicer and month from first slicer then sales should show for 30 days window and if I select static then it should show actual month wise sales

Hi Bas,

I am getting an error of 'circular dependency' upon changing the cardinality to one to many (for dimdate <-> dateperiodbridge relationship)

Bas, You're the best!

Very helpful and wonderfully presented. I really like the updated version to work with "Between" dates. Thank you.

awesome Bas

gold

Great idea, however I have been having trouble to make it work. in my DatesToPeriodBridge table I am getting some values in the beginning of my Dates field that look like this "4/27/0217". Also I noticed in your model view from DimDate to Bridge you have a 1 to * and mine from my selected date it wont let me do that mine is * to 1 due to my main date I have many of the same dates. Can you point me in the right direction. Thanks!

I can see that the min date option is disabled so can you make a video changing the min date as well

I suppose it would be easier to create the ppt background with the boxes first to use the ppt alignment functionality rather than bother with the excel and complex pixel calculations

Im moving into a full time reporting role soon and I love these vids. They've helped enormously as I've gone from 0 powerbi knowledge to running the entire reporting function for my company.

I have a long way to go, but I'll be signing up for your training course next month to help me along the way.

You are artist

Вау, дуже дякую, корисні підказки, взяв собі "в скриню".

Just Amazing !! Thanks, thanks, thanks ! Very nice content !!!!

Hey,
Ive noticed that while using the smart axix, which is awesome btw, there is no option to use the trend line in the line chart. Weird is that if you setup it before using the parameter its kinda there but just for some of the style of periods. Anyone that could help me with that?

Thanks for all your videos, Bas! They help me every day!

WOW, just WOW!

Didn't know that Ctrl+Shift+L trick to select all similar lines in the code!

Wow! It's brilliant!

hello, thanks for your channel!
I try to use this case, but if I have a period of more than 1 year, how does it works Bas? for example if I need a data check for 2 years and in a bar chart I would see data by Quarter and year.
( Now I see only four quarters, but a period of more than 1 year

Hi bob i have the question with smart axis how to sort all the calendar to be correct in graph

Ok, it's a good trick, but if you choose just november for example, the chart will appear as a quarter not in days!
That table DateToPeriodBridge is static. If you choose another year the chart will be crashed probably with a year dot!

It is Awesome. but while the dates go more than a year the X-Axis is not coming in order. Unable to sort it also since it is from Parameter field. Any solutions Please?

Cool, but it works only for static min date, how to do it when the first date can change?

Hi, i have a dashboard creates for supplier scorecard in power bi..i want to export it in pdf and save it to a folder on basis of supplier..its means pdf to be save with that supplier name..total supplier are 500, so 500 pdf files.

Thank you. Perfect Timing as I am having this issue. Love your solution. I learn from your channel everyday.

Can you teach us how to use a Dynamic Query Parameter with date filters please?

Nice video! I think if you leave the calculated table without the relationships, you could simply sync slicers using both dates fields and hide it from the floating slicer. You would be able to get the same result, but much simpler way.

Excellent 😀

Good day
I ave a problem that i am struggling with. I am working with time series data containing weekly prices of beef. The problem is that the new prices for each week comes out on a Friday. The reports that i make goes out on a Monday. My question is i would like to forecast a single value in a card format that use seasonality in the function to forecast a single value for the coming week. This value should not just reflect the previous years value but n true foretasted value like it can be done in excel.
I hope you can help me on this matter.

Why does everyone always put true as the first parameter in a switch statement instead of just putting the field you are looking up the values for. It's a lot less effort to code.

When trying to use field parameters, my X-Axis sorting gets messed up and is always sorting based on values Ascending or descending) and not according to the timeline. I thought this is a bug as this feature is still in preview, but I can see it works fine for you, so it is not a bug.

Any idea how to get this axis sorting to follow timeline and not the values?

Just Wow!!

excellent tips, I am brazilian.

another classic from BAS, thank you for sharing

Really amazing

I received a circular dependency warning when attempting to create a relationship between the dimension date table and the helper bridge table. I believe it’s because the variable references date. How did you get around this?

Excellent stuff Bas!
I’m curious, is there an advantage to doing the SWITCH to specify TRUE and then each line has to specify MonthCount = 0,1,2,3,4 ? I typically put the MonthCount where the TRUE is to begin the SWITCH statement and then each line just has the values I’m looking for, so my statement would begin with SWITCH( MonthCount, 1, “Sales by Date”, 2, “Sales by Week”…..etc

This is kind of videos are why I am subscribed to you! Amazing and thank you for that!.
I don’t want to brag but… I found a solution and got it working with “between” slicer without the need for refreshing:)

Next level 🔥

Thanks for sharing ❤

Amazing!! I'm a fan of your content, keep doing this. Your content is very helpful especially your tricks in the design. Thank you

This is fantastic! Do you have any suggestion when you have to produce a report in two different languages?! How to have this dynamic?

Love this, Bas! I'm going to use this for sure! Thanks!

Ctrl shift L?! 😍

Genius logic

What an awesome simple and fast method. Once again Bas: really helpful! Get yourself some cake n coffe 😃🙏

You are the best

Omg you are Too good 😃😃😃

Brilliant!