Thanks for your support

Hey Mathhew, That might not be possible. But, there might be custom visuals that might offer this solution.

Hey Jack, Cumulative depends only on date column unless there are other columns you are getting cumulative from. Please ensure after you sort the column you desire, press shift key and then sort the date column as well. In this way you will sort the table by multiple columns combination

Any changes made on desktop should be reflected on the uploaded report as well. However, I found Power BI report Server May 2024 version has an issue with this setup but, has been fixed for September version. If you are using Power BI online, there should not be any problem.

Thanks. Happy to help.

Thanks 🙏

add the columns you want to freeze in rows section. Other columns which you don’t want to freeze add to values section. If it is a numerical values, they will be aggregated so make sure you add a text column which is unique. So that it won’t be aggreagtef

Happy to help

On top of my head, it sounds tricky. But, why not try right? I am thinking of an idea if we could create a calculated column in a date table like if date is today or greater than today then get the date which leaves past dates as blanks. But, not sure if this will be any use. Will need to jump on my computer and let you know 😃 keep this tricky questions coming

Hey David, Use one of the columns that is unique in rows section. Maybe ID or key column something. This way there won’t be an aggregation even if there is an aggregation if you know what I mean.

Go to time 1:50 of the video. In this video, I have frozen two columns. But you can add more and follow the same steps. Make sure you drill down until the option has been disabled.

Happy to help. Go to Row Subtotal options and select the row you want to get subtotal for. Ensure you have checked per row level option.

Hey, Can you explain a bit more on what you are trying to achieve?

Glad it helped

Link your date, DateTime or time column of your fact table to the date, DateTime or time table Ensure you create one to many relationship. Hope this helps.

@@powerbitutorialforbeginners I have 4 fact tables 2 with Date and 2 withdatetime. Also 1 Date and 1 datetime tables conected to each other. The 2 fact table with datetime are connected to the datetime table and the 2 facttables with Date are connected to the Date table. Can the datamodell exist Like this?

No problem. Happy to help.

Happy to help.

Hey Daniel, Find the scripts here drive.google.com/drive/folders/1wRaGsy_Cx410y0Dw3n3sJdMfjv-LVxzl?usp=drive_link Instructions in the description of this video.

Glad that it helped

No problem. Happy to help.

Hey Sonam, Could you please elaborate? Between slicer already allows picking from and to date.

Glad you liked it!

Hey there, That is a DAX code. Power Query uses m code. Instead of filter, it uses Table.SelectRows() and List.Sum() Something like List.Sum(Table.SelectRows(newstep, each [Name] = “East”))[ListName] ListName is the list you want to sum from the table newstep. Hope this helps.

Yes. Absolutely. The best way is to filter the dataset in power query for required date and create a calendar table based on minimum value of the table and maximum date value of the table. As Calendar(min(table[date]), Max[table[date]))

@@powerbitutorialforbeginners the issue is, a very typical use case is default to show me the last 30 days, but then let me go back as far as I want. We are Power BI advocates but this is one weak, weak area within Power BI.

Absolutely. Basic stuff. Another example for me would be a date picker.

I don’t think we can do it in a normal table. But if you add a unique text column to values section, it resolves the summarisation issue if that is the issue you are having.

I have uploaded the report and data here: drive.google.com/drive/folders/1OpeTbvWzyCB8w73wVu6QZzaxk9GKeZCh Let me know if you run into any issue.🙂

Very!

Yeah the things we can do with Power Query is unreal.

No problem. Happy to help.

Haha. Look for m query reference by microsoft

Thank you very much 😊 means a lot

Yeah that’s when I realised I need to make another video 😂

Most welcome

Replacing value step applies to the whole column. To replace value for just one row, you might need to perform some extra steps or apply condition using if and else statement. You can create a customs column to do so.

Hey there, Did you mean ordering pages? Can you explain a bit more on this please? Thanks

@@powerbitutorialforbeginners yes it's like we have given a drill through for multiple different pages that is for eg: salespage, profit page, analysis page, clientspage now I would like to sort or rearrange these already created drill through pages in this order = analysis page, profit page, clientspage, salespage. How to achieve this?? Is this possible in drill through??

Hey not sure if I understood this correctly but, the order of drill through pages will get the order as you rearrange the pages in the canvas. First drill through page would always come to first order. Rearrange in the canvas itself. If you want to form like a lineage type order. Then use different columns for each page drill through. Ensure it’s coming from same table. Say for main page you have ID, salesID Use id to drill through sales Use salesID to drill through client and so on This way you won’t see all drill through pages but only the one that you need to go to. Main->sales->client

exactly lol

You should create a calendar table as required. To grey out other dates you don’t need.

Freezing columns in new version here: kzbin.info/www/bejne/aYnHiqevqb2MpJY