Power bi scenario based interview Question & Answers | Dynamic Title based on user Slicer selection
Vložit
- čas přidán 10. 07. 2024
- #powerbi_training #powerbi
Power bi scenario based interview questions and answers both for experienced professionals & Freshers.
Three scenario where interviewer can ask you questions based on DYNAMIC TITLES based on SLICER SELECTION in Power BI
🔥🔥🔥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 !🔥🔥
Download the pbix file from : drive.google.com/file/d/1yRJZ...
Chapters:
0:00 Intro
0:32 1st scenario based question
5:09 second scenario based question on Text color
8:08 third scenario based question on current year
❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Download the pbix file used in this video from :
drive.google.com/file/d/1yRJZpR0NILbpImaBUwMZ0duVIWLsH5NJ/view?usp=share_link
Can you make more videos like this ..its a really great informative series
More to come!
for third question this also work
SWITCH(SELECTEDVALUE(financials[Year]),
2014,"current year ",
"sales in " )
Yes bro ..It depends on the logic
Wonderful brother great work kudos to your efforts 👏👏👏
Thank you so much !
Tysm for your time n efforts
Most welcome dear! Happy learning
Thank you sir
Welcome Akshay!
very nice thanks
Most welcome
Very nice video.
And one more que. How did u do that animated card.. Advertisement type.
thnx Nimika .. I had used a viz called scroller and cretaed a hardcoded column with the scrolling text .If you like my videos plz do subscribe :)
@@powerbizone Thank you for providing this option.
@@nimikajadav3004 Most welcome !
nice bro
thnx bro
What will happen if chart size is small & user need multiple selection ( consider 3 years)
I will try to make a video on multiselect year soon..For chart size you can alwys adjust fonts .
In sales table we have products and some agents name.letz say there is a product xyz and there is an agent name A and there are sales given month wise Jan ,Feb....how to write dax to provide sum of a sales by agent A of product XYZ in the month of JAN
Hi Sakshi..Sorry am travelling as we speak .Why dont you just drag the product , Agent and month column in a table .That will give their unique occurances.Then simply create a sum(Sales ) measure.
@@powerbizone how to do this using dax?
@@sakshinaik05 Well it depends on your data and the columns you are pulling in your visual.You have to provide me with more details as I am not sure what is your exact requirement dear. As far as i understand your problem .drag the product , Agent and month column in a table and create a simple dax of sum(Sales)