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...
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...
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
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?
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.
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 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
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
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
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?
This was an incredible example. Nags please keep adding a REAL TIME SCENARIO based Question and Answers too.
Sure thanks keep learning
Yaa , today I did one aggregate with selected value, but based on requirements we have to think Function n logic
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...
HE CREATED MEASURE WITH SELECTED FUNCTION ,THEN ITS WORKS FINE WITH OUT RELEATION BETWEEN TABLES
Thanks for the great example.
thanks , keep learning
Superb Explanation
Glad you liked it
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...
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
Sir without variable
Can we do this same scenario with switch and selected value function.
Please tell me.
Yes. There are different ways to achieve the results. This video main purpose is to showcase when you can go for variable
@@AnalyticswithNags thanks you so much sir
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?
Visual header property
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
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.
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 ?
Use previousperiod or dare add function. Check in Dax playlist
But would it work for a text value ? Like for eg i want previous month rating which is like AA,B etc
Good explanation....if you put raw data also good for us..pls add rawdata also
Will upload soon
@@AnalyticswithNags because if you data more people watch your videos... Pls add video wise...
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??
Soon I will make a video on this
@@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
Thanks for good topic
Welcome
Good explanation, subscribed
Cheers. Keep learning
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
Use switch function
Explore the similar problems here, learn.microsoft.com/en-us/answers/
Super. I understand
Keep learning
Please provide dataset in the description box.
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.
Answer in this video th-cam.com/video/hJLOBvn_f8k/w-d-xo.html
in dimdate table, whats the difference between month and monthnum column? if u have data, can u pls share
Month can be Jan, feb. Month no is 1,2,…
Monthno used to order the Month column
Thanks a lot 🙏
Thanks keep learning. Share this channel with friends and colleagues
so usefull sir,keep upload pls
Thank you, I will . Keep Learning
Please start Other Technologies Like ADF, Synapse etc....
Soon we will start it
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
Already used the selected value variable in calculations
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?
Explore the similar problems here, learn.microsoft.com/en-us/answers/
how did it work without even completing calculate loop
Not source about your question
It's great content...
Sir please share reference data for the practice...
If data is not in the desc, then its simple data you can prepare it yourself in excel for your use.
Sir waiting for it sir if possible then try to upload more than one video plz.
Sure
Sir maku sales table meru echina data lo ledu kada
Didn't understand what you are trying to say
@@AnalyticswithNags
Hai sir please send me the source file