Video

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

❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥 Mail your Queries at : yourpowerbizone@gmail.com Download the pbix from: drive.google.com/file/d/15Hh7LpgLR2g6UFCZrNdmkiRa-yzXRbJU/view?usp=sharing

Suppose I have 2 preselected slicers product and month dependent on each other, On selecting a product from the product slicer i get the default minimum month selected on the month slicer, when I change the selection on the month slicer manually, and now I go back and select another product on the product slicer, the default on the month slicer vanishes, nothing is selected by default. I need to reset and get back the default selection. Can this be avoided? I mean I do not want to use the reset button.

hi chatgpt has provided below code as output , could you please make a video on it too CONCATENATEX ( FILTER ( ADDCOLUMNS ( GENERATESERIES ( 1, LEN ( 'Table'[Alhanumeric] ) ), "Character", MID ( 'Table'[Alhanumeric], [Value], 1 ) ), MID ( 'Table'[Alhanumeric], [value], 1 ) >= "0" && MID ( 'Table'[Alhanumeric], [Value], 1 ) <= "9" ), [Character], "" )

Download the pbix from : drive.google.com/file/d/1hv4bDhF_x5OZozHJ_tP2ejhAmGmNdVAd/view?usp=sharing

Keep up the good work 💪

Download the pbix from: drive.google.com/file/d/1RhjrmblKLg7SYHZ68LS_rhnjDK295t3p/view

Great explanation, thnx!!

Very well explained. Thanks a lot

Hi, thank you for the video, I have a question , let us say I want to exclude both the filters in the table shown. Can we do that. So the formula would be AllSales = calculate( sum(financials[Sales]), all(financials[country]), all (financials[year]) I am assuming that year column belongs to the 'financials' table. is it possible to add 2 or more filters in the all function calculation?

wow!!!!!

Please keep posting such interview problems more frequently.....

Promo'SM 🙌

Excellent video . Your content is top notch

Can you show us how to extract only numbers like you did alphabets..great video

Great content as usual..I never knew we can use substitute like this ..thnx

Very good video. Thanks for explaining this so clearly. Is there a way to get rid of '1' that appears on the column subtotal?

awesome! short & crisp but effective! Thanks

😍

I have a similar goal to the tutorial you provided; however, in the case if you were to filter out a country like united states, I would like the cumulative total to start at the next highest country. Could you provide insight to how that can be done? Many thanks!

Good explanation . Thank you

sir..awesome..saved lot of time