Scenario: Highlight Max and Min Sales in a Line Chart | Power BI Interview
Вставка
- Опубліковано 21 сер 2024
- Topmate Link to book call 1:1 - topmate.io/lea...
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / shashank_nikumbh26
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
#powerbiinterview
#learnwidgiggs
Just a smaill correction here, use country column when using 'ALL'
Max_Point =
var Max1 = MAXX(all(Orders[Country]),[TotalSales])
var Max2 = IF(Max1 = [TotalSales], Max1, BLANK())
Return Max2
Max Sales =
CALCULATE(
MAX(Sales[TotalSales]),
ALLEXCEPT(Sales, Sales[Country])
)
thanks for your great scenarios and i request pls give the sample datasets with the scenarios for best practicing.
Thank you ...with your videos i improved lot in dax ..
Glad to hear this.
we need to complete 10 page report in a short span , they assigned two BI developers under you. Now question was: How would you decide steps for the flow of project.
How would you answer
Hi, I following all your dax videos and gaining so much of knowledge
Glad to hear this 😊
@@learnwidgiggs Please make a video on complete RLS - Static RLS and Dynamic RLS
It will be helpful for us
Excellently explained new Dax
Thank you 😊
You’re videos are really helpful and thank you so much.
If possible pls post one end to end realtime scenario project in power bi
welcome, will plan.
Thanks for another great scenario based qs
Welcome 🙂
Thanks for another great scenario 😊
Welcome 😊
What table 3 contains? Which table to use in all function?
Thankyou for sharing sir ❤
Welcome deepanshu 😊
Thank you sir, keep it up
Welcome😊
This Dax doesn't work in 2024 , power bi does not allow direct column name in If statemnet . the TOTAL SALES you mentioned in the DAX is not support now. Please clarify how to proceed.
Thank you sir for providing information..
What are the types of KPIs?
KPIs are different for different domains of reports
But the problem is that we can not drill down further. Do you have any solution for that also?
Thanks For Good Content
Can We same find Avg point in this line chart?
I have a Card visual with Total Sales. I have a country slicer and if I select a country the sales of that country is visible in Card, but if I do not select any country in slicer I need the sales of India in card visual. Can you explain this. This was an interview question.
Use selectedvalue Dax
I have already covered this scenario in one of the previous video.
Instead of Maxx can we use this way
Calculate(max(total_sales), all(table3))
I don't think so, if this will work.
max(y) works only if y is a column . total_sales is a measure and cannot be used with max.
However you can create a new table and use maxx on it
Max_Value =
var t = CALCULATETABLE(
ADDCOLUMNS (
'Table 3',
"@TotalSales", [TotalSales]
),
ALLSELECTED ()
)
return MAXX(t , [@TotalSales]) but MAXX is the short version
can you suggest me how to take max & min values based on four columns in matrix....those 4 columns are not direct columns they are written as measures.....so that those 2 values should be used in conditional formatting of those 4 columns and color it like heat map....Please suggest
please the share the PBIX file with your videos if possible . It will be helpful for us to practice simultaneously .
could you provide us with the sample data to practice on?
Nice
thnx
Hi Shashank,
Can u pls add pdf or something like material for interview purpose? I need pls
Are you created Datatable "Table3"? this is not explained how to create
Using Calender DAX function.
Hello, Thanks for the video but I am getting blank instead of max value. What could be the reason ? Please help
Data Labels should be on, drop down the data labels,apply setting to,series(select Total Sales measure),turn off the Show for this series option.
Thank you for the video. In this case, say I use
MAXX(ALLSELECTED('Table3'[Country],[Total Sales])
If I use Field parameters and try to switch between dimensions country/region + somemore from other tables, how you I do an allselected of field parameter's selected dimension. Could you suggest
what about powerBI calls in may months...???
Why was ALL used here. What would be the difference without ALL
To ignore the filter context if any already exists.
When u apply a measure on any visual, the measure gets filtered by default (depends on the fields that you have used along with the measure in the visual), in this case you’ll not be able to get the max and min values without using ALL function.
ALL function avoids the filter context in the visual. Hence, the measure identifies the max and min values from the column.
@@HappyAnalysing thank u so much alekya ....i confused alot whenever i saw using this ALL function in measures...with your words i can understand clearly what is going on with All function in measure
Hey, Is there any special DAX in total sales?
Its a simple measure using SUM()
@@learnwidgiggs The max point is not showing for me.. Will check again..
@@soutikkumar2750even for me Max point is not showing
plz provide the dataset to practise
Hey. Can we change dynamically column name.
Suppose in Slicer if we select January . In the table i want December sales along with title should be December
Yes it's possible
Please make a video on that
Try to make it as soon as possible. I stuck due to this
I think this should work according to your requirement.
SelectedMonthSales =
VAR SelectedMonth = SELECTEDVALUE('Date'[Month])
RETURN
SUMX(FILTER('Sales', 'Date'[Month] = SelectedMonth), 'Sales'[SalesAmount])
Hello sir. Is it possible to get job in power bi after 10 year gap with out fake experience?
Little difficult to justify the gap. If you can justify the gap, you may get the job.
What would you recommend as the best way to learn dax
Practise the scenario based questions yourself as much as possible.
PLS SHARE THIS DATASET
Plz reply
thanks for your great scenarios and i request pls give the sample datasets with the scenarios for best practicing.