🔥🔥 Power bi scenario based interview questions & answers for experienced professionals & Freshers 🔥🔥
Рет қаралды 13,143
Күн бұрын#powerbi_training #powerbi
Power bi scenario based interview questions and answers both for experienced professionals & Freshers.
1.How can you Extract a username from email address using DAX?.
2.How to "Clear All Selected Filters" by clicking an image/button?
3.How do you display the slicer's selected value ?
4.Click button1 to go to navigate to Page1 and button2 to go to navigate to Page2: Page navigation concept
5.How can you Hide All Visuals and See All visuals at click of a button? using bookmark On same page
🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉1.SamePeriodLastYear with Example: • difference between par...
👉2.How to Calculate Running Totals: • How to calculate runni...
👉3.Duplicate Vs Reference : • power bi difference be...
👉4.Merge Vs Append: • power bi difference be...
👉5.Calculate Function in DAX Power BI: • What is Calculate Func...
👉6.Filter Function in Power BI: • Filter Function in Pow...
👉7.Row Vs Filter Context: • Row Context Vs Filter ...
👉8.ALL DAX Function: • How to use ALL Dax Fun...
👉9.ALL Vs ALLSELECTED : • allselected dax|all vs...
👉10.ALL Vs ALLSELECTED VS ALLEXCEPT : • All Vs AllSelected Vs ...
👉11.ALL Vs REMOVEFILTERS : • ALL Vs REMOVEFILTERS D...
👉12.TOPN Dax Usage : • TOPN Dax | How to use ...
👉13.Summarize Dax Function in Power BI: • summarize dax | How to...
👉14.Summarize Vs Summarizecolumn : • summarize vs summarize...
👉15.Calendar Vs CalendarAuto : • Calendar Vs Calendar A...
👉16.How to create a date table in Power BI : • how to create a date t...
👉17.How to calculate Running total for date values in Power BI
• How to calculate Runni...
👉18.How to calculate running total in power bi for non date values: • Running Total in Power...
👉19.Usage of datediff in Power BI: • Power BI datediff dax ...
👉20.Isblank() Vs Isempty : • Power BI ISBlank DAX F...
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
powerbizone.com/category/arti...
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Chapters:
0:00 Intro
0:19 Interview question Q1- Extract a username from email address
4:18 Interview question Q2-Clear All Selected Filters by clicking a button
8:53 Interview question Q3-display the slicer's selected value
10:11 Interview question Q4- Page navigation concept
12:28 Interview question Q5-Hide/ Show All visuals at click of a button using Bookmark
@powerbizone Жыл бұрын
Hi guys .you can download the pbix file for practice from below link. drive.google.com/file/d/1p_dT3AFInFIvAlcfyD3-c0V06C16-yr9/view?usp=share_link ❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
@HappyLandTravel 10 ай бұрын
Thanks for making this video. Its really helpful tip!
@powerbizone 10 ай бұрын
Glad you enjoyed it!
@saltpepper9062 Жыл бұрын
Excellent content.thanks 🙏
@powerbizone Жыл бұрын
Thank you bro
@sandeshpadigela2079 Жыл бұрын
Fantastic , keep it up.
@powerbizone Жыл бұрын
Thanks a lot Sandesh!
@swatichoudhary9718 4 ай бұрын
Very much needed. thank you.
@powerbizone 4 ай бұрын
You are most welcome :)
@karanmalkhede6689 Жыл бұрын
Excellent video
@powerbizone Жыл бұрын
Thank you Karan !🙂
@madhusudhanreddyt2838 18 күн бұрын
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"
@powerbizone 17 күн бұрын
thnx ..yes it was introduced recently ..i will try to make a video on this ..thnx for being vigilant & pointing out Madhusudhan .Also, If you like my content do subscribe .Bye.:)
@madhusudhanreddyt2838 16 күн бұрын
@@powerbizone Always welcome!!!! I know the pain it takes to create these videos to help the community and share the knowledge...All the best for future videos
@powerbizone 15 күн бұрын
@@madhusudhanreddyt2838 thnx
@madhusudhanreddyt2838 16 күн бұрын
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")
@powerbizone 16 күн бұрын
thnx for helping out the community Madhusudhan :)
@sakshinaik05 Жыл бұрын
How to check loading time of the any visual?how to avoid it if visual is taking 10 sec to load and that visual is very important
@powerbizone Жыл бұрын
Go to Format-->performance analyzer to see the timings. As to optimize your query/visual timings is a lengthy process sometimes depending on your data and complexity of measures. Check this out : community.powerbi.com/t5/Desktop/Power-BI-Desktop-Visuals-slow-load/m-p/252881
@amolvgopewad5158 Жыл бұрын
Really very good content 👌👌 All Videos kal rat se sab videos dekh raha hu 👌. Sir if possible can you share the dataset. Csv Thank you🙏
@powerbizone Жыл бұрын
Thank you so much Amol !It is comments like this that keeps me motivated ..Mostly i use either financials excel or Adventure works (from Microsoft website). You can download the pbix file for practice from below link. drive.google.com/file/d/1p_dT3AFInFIvAlcfyD3-c0V06C16-yr9/view?usp=share_link
@bhangura3026 Жыл бұрын
What's the answer for 3rd Question ? Does all function Override a page level filter or Report level Filter
@powerbizone Жыл бұрын
It overrides both
@bhangura3026 Жыл бұрын
@@powerbizone which means Report Level Filter right ?
@powerbizone Жыл бұрын
@@bhangura3026 :yes it will override report level too
@ankitbedi8767 Жыл бұрын
Username = LEFT([Email], FIND("@", [Email]) - 1)
@powerbizone Жыл бұрын
:)
PowerBI Zone
Рет қаралды 3,2 М.
Data Tutorials
Рет қаралды 79 М.
PowerBI Zone
Рет қаралды 3,6 М.
Data Tutorials
Рет қаралды 21 М.
Data Tutorials
Рет қаралды 5 М.
Data Tutorials
Рет қаралды 16 М.
Questpond
Рет қаралды 99 М.