Видео

How do I freeze more than 2 columns, when I try your technique only two show the others are not visible.

what if u had 5000 rows of data; and the value you wanted to change is located in the midst of column, you need to scroll down and find that value. This technique u taught here is very difficult and cumbersome to apply. come up with better idea, I also want to learn

Thanks for this, really helpful. But, how do i add grand total at the end ?

Can you tell me how to deselect the date ,, to see the whole month data ,, can you please help me out

Useful. Thanks

👏 How to Set Up the Relations in the datamodell?

Thank you so much for this video Rosh❤

Very nice video, thanks for it <3

Access scripts here: drive.google.com/drive/folders/1wRaGsy_Cx410y0Dw3n3sJdMfjv-LVxzl?usp=drive_link

Hello thanks for the video, but I do not see the scripts in the description as it says in the video. Any help?

Thank you, this works really well. As an added benefit, when used with line chart viz, it happens to align every data point to the same time frame for different visualizations. And of course, it's very elegant and simple.

Thank you so much... you save our day today

Hey Rosh! great video - thanks for sharing. Is it possible to Type "From" and "To" on top of the slicer calendars when using the BETWEEN property?

Thanks for this great video.

? newstep1=Table.InsertRows(newstep, 0,{[Location=SUMX(FILTER(Location - beginner, Location - beginner[Name] = "East"), Location - beginner[Location]) ,address='1.sum', Name=null ]}) how to add total row for Name[East] column? i thought so but it doesn't work! help me

Your first date is still defaulting to the absolute minimum date. It could be 20 years, meaning 20 years of data trying to populate by default. We also need to set the default START date to some value, such as last 7/30/60 days.

Is there a way to do this with the normal table and not the matrix please?

Can you share the source file and pbix to follow along?

Sweet!!

That’s awesome. I didn’t know about Unichar in Power Query. I did know about DAX function. But good to know.

Thanks man, saved a lot of time

How do you know these stuff?

Another power bi treasure channel

Finally, someone got it for the newer version. I was confused on the old one. There was no option to turn off stepped layout. Thanks heaps

Thanks a lot

This was exactly what I was look for. Thanks a lot!!!!!!!!!!!

Thanks for this video. This was really helpful. 😊😊😊 no issue with the AI voice

Freezing columns in new version here: ruclips.net/video/3XdYtytXYn4/видео.html 🗞🗞🗞

how to replace one specific value? Just the one row i am selecting ? thank youuu

After I have created the multiple drill through pages what if I would want to sort in different order how to do.. Please can you come up with an video on this. Pls help

I wanted the second date slicer you have created. but my requirements is that whenever a new user open the report he should always get the max date from the table. how can I accomplish that?

This is not the solution, why user doesn't change the slicer dates. If we do not touch the slicer then what is the point of adding slicer in the report.

Hi. Can you please let me know if I can do the same for the start date to select it to a default value every week? The end date will be the most recent data and the start date will be 2 weeks ahead of it. But I should be able to see previous weeks also in the slicer. Thanks!

Hi I just wonder what If I only want to add 1 value (for example the title) at the first column instead of gotta fill the whole row (given the table has many columns and I don't want to go put the rest column = 0)

you wasted 4 minutes to get to the point

Is there a way to define a default date, for example, yesterday, using this method?

Excellent tool! Is it possible to gray out the days without data to avoid selecting them unnecessarily?

there is no stepped layout

How to have a same date picker visually but it should select range of values? (Like journey start date till journey end date all the dates in between)

Good work. How to get list of dates between two DateTimes?

Nice tutorial Rosh.

How to put total column and total row?

damn that's amazing, thanks! Watched several videos struggle with this, great and simple solution

Great info on slicer, i need help on as i am using two different column for date filter as start date and end date.

Thanks! In Dax, I used the same concept of creating a commum column and I used "crossjoin" function and it worked as well. But, the cross join function does not accept columns with the same name, so I named then as "KEY" and "KEY2".

Why would you want to manually code like this? Makes no sense. My suggestion, albeit more work but far more manageable would be add row in a csv file, import this data and append to the database table, that way the data is separate from the visuals and far easier to update and debug.

Thanks this is informative 😊😊 How do I Automatically add a calculated measure to a new row everyday along with date in separate column ( Date stamp)

Thanks man, really helpful. It's simple though but most of the developers knows the struggle behind it as It's the basic thing the user wants in the report.

We need to show last yesterday date selection with date between slicer and it can be changeable according to user requirements. please help me on this

can we create the date table from min slicer to max slicer selection? so it would always change.