What is Selected Value in Power BI DAX Tutorial (26/50)

[@mohitupadhayay1439]

This was an incredible example. Nags please keep adding a REAL TIME SCENARIO based Question and Answers too.

[@AnalyticswithNags]

Sure thanks keep learning

[@jayack1927]

Yaa , today I did one aggregate with selected value, but based on requirements we have to think Function n logic

[@ranasoleimani4650]

Thanks for the great example.

[@AnalyticswithNags]

thanks , keep learning

[@RajeshManepalli-o8b]

Superb Explanation

[@AnalyticswithNags]

Glad you liked it

[@saravanasak]

Thanks for good topic

[@AnalyticswithNags]

Welcome

[@shivyogi806]

Thanks a lot 🙏

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@ManaTelugodey]

Good explanation....if you put raw data also good for us..pls add rawdata also

[@AnalyticswithNags]

Will upload soon

[@ManaTelugodey]

@@AnalyticswithNags because if you data more people watch your videos... Pls add video wise...

[@Entertainmentmod]

Super. I understand

[@AnalyticswithNags]

Keep learning

[@noushadaboobakar6492]

Good explanation, subscribed

[@AnalyticswithNags]

Cheers. Keep learning

[@classybeats2891]

so usefull sir,keep upload pls

[@AnalyticswithNags]

Thank you, I will . Keep Learning

[@basavaj474]

Sir without variable Can we do this same scenario with switch and selected value function. Please tell me.

[@AnalyticswithNags]

Yes. There are different ways to achieve the results. This video main purpose is to showcase when you can go for variable

[@basavaj474]

@@AnalyticswithNags thanks you so much sir

[@shivamkathpal-y3c]

Hi Nags, I have a question like , did we make relationship between Sales table and our newly created MonthList table and if no then how it is filtering sales amount with the newly created month filter...

[@daskurapati1601]

HE CREATED MEASURE WITH SELECTED FUNCTION ,THEN ITS WORKS FINE WITH OUT RELEATION BETWEEN TABLES

[@aakashkrsinha]

Hi Sir, I need a help as i am new to power bi, how can we do the same for week wise filter, i want to show last week performance basis on the week filtered, is it possible to do so??

[@AnalyticswithNags]

Soon I will make a video on this

[@aakashkrsinha]

@@AnalyticswithNags I want to take complete package of power bi, i liked the way you teach/explain. Let me know if you provide online classes of the same and fees

[@phillipk9891]

How do you hide those 3 options incl the three dot ellipsis when hovering a dashboard on some visuals like card, slicers, textbox, tables, etc. Are there any fancy or creative way of hiding those settings?

[@AnalyticswithNags]

Visual header property

[@phanindrayamsani8324]

Hi sir, the selected value is working good with only one selection in a filter but which function i can use for more than one value is selected in filter please let me know sir

[@babajipal3883]

Use switch function

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/

[@krutikapatil4986]

Hi sir , what if i have jan 2021 data and i want previous months like say nov 2020 and dec 2020 , will this work in that case ?

[@AnalyticswithNags]

Use previousperiod or dare add function. Check in Dax playlist

[@krutikapatil4986]

But would it work for a text value ? Like for eg i want previous month rating which is like AA,B etc

[@dhinesh1733]

in dimdate table, whats the difference between month and monthnum column? if u have data, can u pls share

[@AnalyticswithNags]

Month can be Jan, feb. Month no is 1,2,… Monthno used to order the Month column

[@lakshmischannel1884]

SIr .. Summarize table use chesaru kada so no need to define any relation between DImdate and Sumarize table? How it is going to work in visualization

[@AnalyticswithNags]

You should not connect... That is the whole logic....This is called disconnected dimension... You will get selected Value from the disconnected dimension..... Then use that value in the calculations.

[@krishnaprasad-pc1et]

its very much useful function sir.. i would like to clarify my doubt like.. if i have data from June till december and from january till may i dont have data. in a visual it has to show that Data not avalable for jan, Data not available for feb, so on for the first 5 months if we filter by month wise. could you please help me out in this.. Thank You very much in advance sir...

[@AnalyticswithNags]

We can’t show text value some members and numerical values other members(months). You can show custom messages when there is no value in chart. Check the video regarding custom messages in the channel

[@karthickom4596]

Sir when we have connected tables in our data, how to get the same result like while filtering particular month will return till that month.

[@AnalyticswithNags]

Answer in this video kzbin.info/www/bejne/nnuvgHWso8SZbs0

[@josejoel9346]

Please provide dataset in the description box.

[@Rajashekar-us2dw]

Please start Other Technologies Like ADF, Synapse etc....

[@AnalyticswithNags]

Soon we will start it

[@venkataranganadh7556]

sir we created month list table right? why dont we refere monthlist or month number from that table,why you used dimdate table while filtering in calculate function

[@AnalyticswithNags]

Already used the selected value variable in calculations

[@adityabodake1165]

how did it work without even completing calculate loop

[@AnalyticswithNags]

Not source about your question

[@pvirendra5]

Is there in power BI any Dax wherin we can find out our requiment Requirment : i have entire 2023 sales data in power BI, in the comparison chart i want se current month vs last month sales ,if i will select Dec month then chart should be Nov vs Dec only Please let us know sir if you have any idea on this?

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/

[@akshaynikam6628]

It's great content... Sir please share reference data for the practice...

[@AnalyticswithNags]

If data is not in the desc, then its simple data you can prepare it yourself in excel for your use.

[@piyushpathak7311]

Sir waiting for it sir if possible then try to upload more than one video plz.

[@AnalyticswithNags]

Sure

[@dvinaykrishna66vinaykrishn17]

Sir maku sales table meru echina data lo ledu kada

[@AnalyticswithNags]

Didn't understand what you are trying to say

[@dvinaykrishna66vinaykrishn17]

@@AnalyticswithNags Hai sir please send me the source file