Good teaching style

great explanation man!

Hello Sir, thanks for the Video. At the end why do we use the FORMAT function and why not CONCATENATE function?

How will calculate the size of data modelling.. Like if you are not able to understand this i wll explain, we will design and develop in power bi desktop once it completed, we will publish it. Then we download for another change at that time we may get the size of pbix file however we need to know the size in power bi workspace . how willl you calculate it ? can you answer thisquestion ?

very helpful video

Amazing explanation tq

Very Nice Explained !

This is the better way of explaining the concepts very clearly

Good one.This would be a really tricky one ...

Thank you so much

Best video I have ever seen thanks for info

The best explanation I have ever seen. Thanks sir

Excellent video as always..thnx for helping the community

I did not know the working of "data".Thnx for explaining :)

Bro in this video u changed the 4th n 5th value 😢 it is adding the alpha values also for this give a suggestion to resolve itn

Thank you sir it helps me a lot I struggle for 1week

Sir can you show a complete page with buttons, icons and bookmarks and also slicer panels for better clarity please

Great content as usual.learnt a lot watching your videos..thnx buddy

The best explanation in the internet ...

Very helpful and clear explanation! Thank you very much. Subscribed.

In Power Query, Using the Custom Column, For Alphabets Text.Remove([CUSTOMERCODE], {"0".."9"}) For Numbers Text.Remove([CUSTOMERCODE], {"a".."z", "A".."Z"})

Thanks..I just faced this question in TCS recently.Your videos are really easy to understand

Thankyou sir. But when I applied the same steps at the end in slicer its by default selecting "All" instead of lastest month could you please suggest me where I am doing wrong

one easy way is to select the column on which you want to apply the formatting and then select "Currency" in the format section..which in turn is going to replace the -ve sign with () or else create a calculated column with below dax code: SalesValue = FORMAT(Sheet1[SalesAmount], "#,0.00;(#,0.00)") and then create another calculated column with below dax code: Sales CF = IF(Sheet1[SalesAmount] > 0, "Green", "Red") Go To SalesValue, Conditional Formatting and select Font color.. select Field Value in Format Style and select the Sales CF...

Thanks for the video, Sales Amount Currency = FORMAT ( SalesInfo[SalesAmount], SWITCH ( SalesInfo[CountryName], "India", "₹ #00.00", "United States", "$ #00.00", "France", "₣ #00.00", "Japan", "¥ #00.00", "England", "£ #00.00" ) )

little simple way to avoid any confusion between the currency and percentage, we can use the below dax to create calculated column Output = FORMAT(Sheet1[Mixed], SWITCH(Sheet1[Type], "Decimal", "$00.00", "Percentage", "00.00%"))

not only hiding the filters pane..we have an option where we can lock the filters at the visual level and the page level so that once you publish the report to the power bi service and share the report with others..they will be able to see the filters pane but they will not be able to edit the filters or modify the filters...

Grt Videos Sirji

Very useful.

extension to the above question where we need to display the country name when you select a country in the slicer.. if you need to display list of countries by a delimeter when you choose multiple countries in the slicer, use the below dax expression in the measure, Selected Countries = VAR _countriesList = CONCATENATEX(DISTINCT(Sheet1[CountryName]), Sheet1[CountryName], ", ") RETURN SWITCH(TRUE(), ISFILTERED(Sheet1[CountryName]), _countriesList, "Please Select Country To Display")

Hello Sir, Can u pls make the video on End to End Powerbi dashboard report.

Grt Video Sir

to clear the filters for all the slicers we can a new option available in power bi...where we can go to the actions of the image object and select the type as "clear all slicers"

grt explanation Sir, Keep it up.

The link to download the file : drive.google.com/file/d/1-wg3TDunOhgolKKqeGAjEKldcwy9xdd-/view?usp=sharing Do not forget to subscribe to get all the latest updates ,tricks & tricks on power BI.

can u pls make a power bi project using most of the scenarios you have covered?

share the file !

Very nice. This may very helpful in my project as i am working on finance project. We can use min and max word rather than putting high or low values. Bcz i am using this thing.

Guys dont forget to like and subscribe ! Link to the pbix file: drive.google.com/file/d/1GJnYx7lFtZsMlAPZksO05UF2Wj8bUxAx/view?usp=sharing

Very nice video. And one more que. How did u do that animated card.. Advertisement type.

So easy to understand thank you so much sir

👌

Excellent..top notch content