I have created this channel to share the knowledge in Power BI. This channel aims to provide power bi tutorials to Power BI users of all level including beginner and intermediate learners. My channel is focused on providing beginner training in Power Bi, Power Bi Tips and Tricks videos and others to save your time and build awesome reports.
My key focus would be to provides tutorials on DAX, visualisation and M query tutorial for beginners.
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.
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
@@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
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)
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 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.
@@powerbitutorialforbeginners so basically, the DateTable = calendar(Allselected(min(date)) , Allselected(max(date)) ) --> so the datetable are based on selected slicer that applied on the dashboard
Brother 1 question. I've been grappling with a bit of a challenge in Power BI, specifically regarding date filtering, and I was hoping to get some advice. Here's the scenario: I've set up a "Date" table in Power BI that spans from January 1, 2000, to January 1, 2030. Now, what I'm aiming for is to have a date slicer or filter on my dashboard that automatically defaults to the current week, meaning from the first day of the week through the last. For instance, today is March 15, 2024, so ideally, the slicer should default to March 11, 2024, through March 17, 2024. However, here's the kicker: I also want users to have the flexibility to select dates outside of the current week if they need to analyze data over a longer period. So while the default setting should always be the current week, users should be able to freely adjust the slicer to their desired timeframe. I've been tinkering around with Power BI, but it seems like achieving this functionality isn't as straightforward as I initially thought. It feels like Power BI might not be as intuitive in this particular area. If anyone has any tips or suggestions on the easiest way to tackle this issue, I'd greatly appreciate it. Thanks in advance for any help you can provide!
Create a column named current week indicator in date table. 1 for current week every week and 0 for others. Drag dateslicer on the visual and on the filter pane. Add the current week filter. Set value = 1. This gets the visual set for current week. How about create a new page or bookmark. But, for the other page/bookmark. Set current column indicator value both 1 and 0 meaning all dates. You can now add a small button or icon in each page indicating users to switch between current week and all weeks. If you keep the visuals exactly the same, the transition would be smooth as well.
What if you want to set the default to the month previous but still want to allow user to pick their own dates e.g. default to month previous but allow user to go 3 months back
Hi Rosh, this is informative video .. thanks. Can you please share details about how to create and update BI report from shared space URL in real time ? Kindly advise please. Thanks.
Thank you for the video, I found it is very helpful! May I know how to put date format into the M code? For example, one column is date, and we need to add a row including a new date.
Hey Judy, I think if you want use custom date use #date(2023,01,01) or #datetime(2023,01,01,12,00,00) Format is #date(year,month,day) for date #datetime(year, month, day, hour, minute, second) for DateTime Do not use “” quotation
Great tips. But I wonder, what if the table have a lot of rows, say a thousand or two thousand rows, how can we make the location (row index) more dynamic? Is there M code that automatically know what is the last row so we can add + 1 to make a new row?
Hey there, You can always use List.Count() m function to get the last index. You can use Table.RowCount() as well Ensure it is subtracted by 1 since index starts at 0. Pick a function based on how much time they consume.
First time seeing your content and I must say it was very organised and simple to follow. Do you by any chance have any workarounds for doing two different date pickers for one visual? Say something similar to what you’ve done but with another date picker which would act like a ‘finish date picker’ so that the first one would be a ‘start date picker’? Many thanks.
Hey Jb, Are we taking about the same table and same column? Because we do have in between options under slicer settings if that’s the case. But if it’s complicated that and you are getting startdate from one table and end date from another, could you elaborate your issue in detail?
Hello, thanks very much for your swift response to my query. Using your Incident table as an example, let’s say you have another date column named ‘Date of response’ aside the ‘Date of incident’ column. So now you have two different date columns in your table. My query was how can you create two date pickers using ‘Date of incident’ column as one and ‘Date of response’ as the other? This can allow a user to pick a specific ‘Date of incident’ and choose a specific ‘Date of response’ to look at. Hopefully this makes more sense than the previous. Thanks again for your help.
@@jbjunior123 Hey JB, Apologies for the late reply. Your case sound similar to a matrix concept of having a row and column and getting values for particular row and column set. For you case, I would create two calendar tables. Link on with column number 1 and second calendar table to column number two. Hence, slicing the dataset with two dimensions. Hope this helps.
Yes we can. Learning M code unlocks new ways we can manipulate and manage data in our report. Not only rows, you can even create your own custom table based on calculations of other multiple tables. I highly recommend people to learn M query.