Very Nice , Thanks

I love this video and was very excited about it but could not get mine to work. I would have liked to have seen his actual formula for the Switch statement

Please share full video

Thank you, struggling to display data, but this video helped alot.

Thank you so much..very helpful 👏👏

Clever approach

Your presentations are so easy to understand. I breakthrough most of my resistances for each video I watch. Thank you so much, and keep the good work up. Regards.

I wanna know who you create that filter. I can get my total sales to filter by year

How did you get the Report1 and Report2 to appear in the “Data - Sales Report” workspace, did you have to publish again? Like you did for the Dataset. Thanks.

Nop Not working. Maybe something is wrong with my bookmark thing. Its not going back to defalt.

I need to know what is duplicate but without removing the information, how can I do that?

Gear Idea, thank you for sharing!

woah! amazing, informative and to the point-- thanks a ton!

Hi sir How to exclude perticular category highrarchy

Thanks a ton @Transformita .. You don't know how much you have helped me by this video. I literally cried after having successful implementation of bookmark in my PowerBi model after watching this video. I have tried everything ChatGPT, Gemini but nothing helped. But this 4 mins of your video helped me a lot. God Bless you brother. Keep up the good work. You earned a subscriber and a well wisher too ❤❤

Good Work. The dude speaks British English which amuses me .... British accent is so weird and hilarious.

you can command switching visual on other device ?

Why doesn't this "Clear All Filters", "Apply All Filters", or "Reset" bookmarks button or any kind of button don't work in the Dashboard view? It works in Power BI Desktop and Service, but when pinned to a dashboard as a whole interactive tile, all slicers and interactions work except the buttons. Any help would be highly appreciated and if possible, asap.

the best and easiest tutorial to follow. Thank you so much

You explained in 3.5 minutes, what some folks are still trying to explain in other videos. Thank you. :)

Omg, this is gold! Thank you so much!

Great video

How to replace the word TOTAL in each sub ROW??

Thanks for the nice video. What if I wanted to switch the order of how month and values are displayed in columns? The desired outcome is Sales-Jan,Feb,Mar then Count-Jan,Feb,Mar ... just to be able to see individual metrics next to each other. This is a standard feature in excel pivot and tableau (there appears a new virtual item "values" the order of which I can control) - cannot figure this out in power BI.

Filters are not Slicers in Power BI - be careful with your naming.

GREAT

That's exactly what I wanted to do in my report! Thanks a lot!!!

writing msg then deleting and then Sure 😝😝😝

I would really appreciate if someone could help me fix the following issue: When I click the "Close&Apply" button in Power Query Editor after adding the dimnsion tables, all the data gets loaded into Power BI with no errors. However, when I look at my dimension tables in data view in Power BI the order of the ROWS is changed. For example, in Power Query Editor, index 1 in the SensorName_Dim table corresponded to "Engine Speed" and index 2 corresponded to "Coolant Temp". After loading data into power BI the order of the sensor names got messed up so that Engine Speed no longer corresponded to index 1 and Coolant Temp no longer corresponded to index 2 . Does someone know how to fix this issue and preserve the order of rows when loading data into Power BI?

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

god bless you

This guy is fantastic, damn lucky I found him.

Great video, solved my problem straight away on displaying the heirachy table.

I am using this feature but when i apply the 'apply all slicer button' the other slicer changes to not yet applied

Great Content !! can you make notes of all the theory of DAX functions you made for accessibility

Where can i get the example file?

Very interesting data model! I'm new to PowerBI and have a follow-up question... When you add the index column to a DIM query, if the source data changes such that a new ZIP Code is added (or a new client), will these index columns not change when you refresh the source data for the query? Will these index values not change and perform as relative-references? I'm concerned that the data will get mixed around when the DIM table merges into the FACT table mid-query. Or am I overthinking this? Will these relative references update safely so that everything merges correctly? Or maybe the issue is that everybody using the fact table needs to understand that Client ID# is a relative reference that can't be relied upon to stay the same from one cycle of reporting to the next.

Great demo. I really appreciated your clear explanations of how to create dim tables. I did have a question about grouping by zip and city though. If you remove duplicates on postal code you could potentially lose some cities since there are some postal codes with multiple cities in them. Can you remove duplicates bas on city and postal code?

Awesome one. Where did you get the icons from please?

No dataset link? What are suppose to fill in this beautiful remarkable extraordinary template with?? LOL

Just what I needed, thank you!

adding the data in the discription could be more beneficial to learn

adding the data in the discription could be more beneficial to learn

Thank you. Can you explain relationships in football data please

It appears the new version of Power BI doesn't have Format > Visual > Row headers > Options. To get the same effect as turning off (what used to be called) "Stepped Layout", it appears you now go to: Format > Visual > Layout and style presets > Layout = Tabular To turn "Stepped Layout" back on: Format > Visual > Layout and style presets > Layout = Compact ... which will then give you the additional option (right under the Layout pull down menu) to set the amount of indentation. Hope that this helps others.

One of best video across KZfaq

Awesome 🎉

If I have two datasets, should I create two star Schema? If yes, how can I manage Dim tables and Facts tables from both datasets?

This was helpful thank you! How would you incorporate an OR clause such as: Count of orders > 500 OR SUM of order amount > 100,000?

This video was helpful. I am currently doing a project on power bi and this explains what i have been looking for. thank you