Scenario: Highlight Max and Min Sales in a Line Chart | Power BI Interview

[@amandev8794]

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

[@datalytic]

Is the [TotalSales] a column or measure?

[@shivangichaudharip-2948]

@@datalytic Its a measure , I think column wont work when we do calculated measure in IF statement like in this scenario

[@padmasattiraju6179]

I am getting two extra straight lines for Maxx and Minx value measures instead of two dots like you showed in the line chart.

[@beingrishi6450]

Im not getting the result is there marker need to be used in format visuals???

[@trikavyam8101]

Thank you ...with your videos i improved lot in dax ..

[@learnwidgiggs]

Glad to hear this.

[@sandhyah6089]

What table 3 contains? Which table to use in all function?

[@bharathkumarthatikonda4982]

Hi, I following all your dax videos and gaining so much of knowledge

[@learnwidgiggs]

Glad to hear this 😊

[@bharathkumarthatikonda4982]

@@learnwidgiggs Please make a video on complete RLS - Static RLS and Dynamic RLS It will be helpful for us

[@rowthulaphani4473]

thanks for your great scenarios and i request pls give the sample datasets with the scenarios for best practicing.

[@sambasivarao576]

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.

[@learnwidgiggs]

Use selectedvalue Dax I have already covered this scenario in one of the previous video.

[@ranjith1083]

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

[@Regans5677]

Excellently explained new Dax

[@learnwidgiggs]

Thank you 😊

[@namrataghosh111]

Thanks for another great scenario based qs

[@learnwidgiggs]

Welcome 🙂

[@gudaprasanna9986]

Thanks for another great scenario 😊

[@learnwidgiggs]

Welcome 😊

[@Blazekidzee]

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

[@learnwidgiggs]

welcome, will plan.

[@vishalsonawane.8905]

Thanks For Good Content Can We same find Avg point in this line chart?

[@marlonetzel6450]

I copied your function and it works, except the data label. IF i turn the data labels off there are non but if i turn them on, there are shown for every data point and not just for the min & max values.

[@meharusia9880]

But the problem is that we can not drill down further. Do you have any solution for that also?

[@atharwaborkar6778]

[@mouniakula-o1q]

Hi Shashank sir, This didn't work for me though am using same dax, its not highlighting only max data label. Max = Var Mmax=MAXX(ALL('Customer'),[sales]) Var Check=IF(Mmax=[sales],Mmax,BLANK()) Return Check

[@hbshemati5138]

could you provide us with the sample data to practice on?

[@bhagisrivally]

Hello, Thanks for the video but I am getting blank instead of max value. What could be the reason ? Please help

[@ShraddhaBisen-ym9xs]

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.

[@thevivekj]

Max Sales = CALCULATE( MAX(Sales[TotalSales]), ALLEXCEPT(Sales, Sales[Country]) )

[@soutikkumar2750]

Hey, Is there any special DAX in total sales?

[@learnwidgiggs]

Its a simple measure using SUM()

[@soutikkumar2750]

@@learnwidgiggs The max point is not showing for me.. Will check again..

[@belliappaka8152]

​@@soutikkumar2750even for me Max point is not showing

[@meghab2910]

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

[@learnwidgiggs]

Yes it's possible

[@meghab2910]

Please make a video on that

[@meghab2910]

Try to make it as soon as possible. I stuck due to this

[@maheshtiwari2297]

I think this should work according to your requirement. SelectedMonthSales = VAR SelectedMonth = SELECTEDVALUE('Date'[Month]) RETURN SUMX(FILTER('Sales', 'Date'[Month] = SelectedMonth), 'Sales'[SalesAmount])

[@NaveenKumar-fq4sb]

what about powerBI calls in may months...???

[@deepanshubhandarivlogs5726]

Thankyou for sharing sir ❤

[@learnwidgiggs]

Welcome deepanshu 😊

[@DilipKumar-ch5uu]

Hi Shashank, Can u pls add pdf or something like material for interview purpose? I need pls

[@deepanshubiswal5315]

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.

[@deboltraja2212]

How would you answer

[@adilumr6359]

What would you recommend as the best way to learn dax

[@learnwidgiggs]

Practise the scenario based questions yourself as much as possible.

[@muruganselva7431]

Are you created Datatable "Table3"? this is not explained how to create

[@learnwidgiggs]

Using Calender DAX function.

[@sakshinaik05]

plz provide the dataset to practise

[@perfectionist6624]

Thank you sir, keep it up

[@learnwidgiggs]

Welcome😊

[@nandinireddy2455]

Instead of Maxx can we use this way Calculate(max(total_sales), all(table3))

[@learnwidgiggs]

I don't think so, if this will work.

[@sr5726]

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

[@anikeetdey3411]

please the share the PBIX file with your videos if possible . It will be helpful for us to practice simultaneously .

[@LaxmiChinta-q1z]

Thank you sir for providing information.. What are the types of KPIs?

[@learnwidgiggs]

KPIs are different for different domains of reports

[@simanchalpadhy-u7m]

Hello sir. Is it possible to get job in power bi after 10 year gap with out fake experience?

[@learnwidgiggs]

Little difficult to justify the gap. If you can justify the gap, you may get the job.

[@kastenivkimbo5347]

Nice

[@learnwidgiggs]

thnx

[@sr5726]

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

[@ashwinkumar5223]

PLS SHARE THIS DATASET

[@adilumr6359]

Why was ALL used here. What would be the difference without ALL

[@learnwidgiggs]

To ignore the filter context if any already exists.

[@HappyAnalysing]

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.

[@trikavyam8101]

​@@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

[@simanchalpadhy-u7m]

Plz reply

[@Chetan_15]

thanks for your great scenarios and i request pls give the sample datasets with the scenarios for best practicing.