how do we connect this to the a copilot studio chatbot, so that query is asked from chatbot
@holahandstrom8 күн бұрын
The most important basic features missing are... 1. Filter by Copy and Paste an Excel list* : This is the use/not use threshold. 2. Sync the Visual when it's copied between pages (in desktop) Most other features are 'nice to have'. *Note : it's common for us to have users with 10.000+ items** in an Excel lists they want to filter in a Sales Report/Table with millions of Sales rows. **The items can be ChassisNo or PartNo etc (=large series with a high complexity, and an 10+ year history).
@sameerunawane10 күн бұрын
what is that selected leader measure defines?
@joshuaychung10 күн бұрын
The pop-up feature does seem great. We're always fighting for that last bit of real estate on the screen. Thanks for the great content.
@onaopepofawunmi560318 күн бұрын
Hello, Please what if i wanted to do a count. I.e as long as the last stock was not blank or zero, i want a count
@AndrédeLange-x9b25 күн бұрын
Very nice, thanks for posting. I will definitely use it now I know how it works!
@KnowledgeBankPro24 күн бұрын
Glad it was helpful!
@tinaflemons26325 күн бұрын
Great video
@Hollywood_-uy3is29 күн бұрын
4:10 "We didnt see any growth" brother u just sjipped over the 4 year recovery of the us from the GLOBAL ECONOMY COLLAPSE IN 2008! The only reaso. The economy looked good during bush is CUZ of the fraud and bs going on with morgages and loans in the US. The fact that we bounced back within Obamas first term was a miracle and how effectice his legislative plan was. U summing up his entire first term as "dont count, we were in the red" is insame, look at th3 slope in the graph compared between trump and obama. Sure trumps number is literally higher. But his slope over 4 yeads is pitiful. Even with consideration for covid. Which he CHOSE to not respond to for months, only making the issue worse for the economy, EVEN IF! his numbers are lack luster and he simply just spent a lot and didnt even start new programs. He just made the rich richer and the poor pooerer. Those who ciulsnt get a home DEFINETLY cant now, and the tarrifs are inly going to raise the bottom dollar of US corps, not the average worker. Idk man, it seems like u had all the tools in this presentstion and simply chose to not use actual statistics snd just went on feel.
@Dasse999Ай бұрын
Im having the exact same issue... Im using wait commands in my pipelines to give that sync job time to finish, but sometimes it keeps failing. Can you please share the code?
@anthonysottile5929Ай бұрын
Great video, I really enjoyed! Have you done a video on how an end user would use this tool? Does there need to be a custom front end built for users to ask questions?
@manikandanraghavan2896Ай бұрын
its really useful, but i wanted to change the starting position name and the ending position name dynamically. could you please help me how can we do that?
@sunyujia7188Ай бұрын
I tried your code, but the synchronization still fails. After carefully reviewing the situation, I found that during synchronization, there are unfinished endpoint queries. If certain deletion commands are executed in the Lakehouse at this time, these queries may get stuck for hours. During this period, all synchronizations will fail. Therefore, I believe your code needs to include logic to kill all running endpoint queries.
@michaelagalati5458Ай бұрын
This is awesome, thank you for sharing these videos :)
@sivachowdary388Ай бұрын
Why it is not working in service
@sivachowdary388Ай бұрын
Please share that code sir
@workstuff5253Ай бұрын
You said this was a Microsoft visual - but its by Inforiver
@KnowledgeBankProАй бұрын
It is part of Microsoft app source. Sorry if that caused any confusion.
@Emilio-s4rАй бұрын
Good stuff, I am not able to find your visual from the PowerBI visuals window. Tried a couple different variations.
@KnowledgeBankProАй бұрын
Try this link to app source - appsource.microsoft.com/sr-latn-rs/product/power-bi-visuals/xviz.inforiver-superfilter?tab=overview
@joaobarbetta2902 ай бұрын
Congratulations for your channel. I am trying to do a waterfall chart in Power BI with subtotals, is there a way? Can you make a video explain it? Thank you very much.
@SatishRathore2 ай бұрын
Perfect solution. Thanks
@marcelocrcfarias2 ай бұрын
thank you for sharing your knowledge, this was very helpful! Also, do you know if there's any way to order the "impact" columns with this new logic you created? The way it is atm, they are ordered by value (greatest to lowest), but I wanted them to stay in a fixed order
@talhanaeemrao43052 ай бұрын
Exactly what I was looking for.. step by step explanation of the whole code and the purpose behind the code.. basically to get the wholesome idea
@amitthorat61832 ай бұрын
Is it possible to access on-premises database systems using Fabric notebooks?
@SPC-q7x17 күн бұрын
No. It doesn't
@JnLDawson2 ай бұрын
Thanks you so much for sharing, this is absolute GOLD! I've been looking for a way to do this programmatically call this refresh for a while as we are seeing very long delays which are hard to predict and work with. I was at the Fabric Conference in Stockholm in September and this was the number 1 issue folks were complaining about. Microsoft has not solution other the recommendation to raise a ticket! Really appreciate you sharing the code here!
@kongfaichow61982 ай бұрын
Hello, your videos are really great. I have a question because I see that the power bi profile in your course only considers one product revenue, but in this video you seem to be able to forecast for multiple products from Prod 0001 to Prod 0126. How to do it? Thank you in advance.
@sa-vi53512 ай бұрын
Awesome video, This helps a lot to create navigation button in BI, Any idea if we can make similar button for bookmark ?
@bhagisrivally2 ай бұрын
While I was trying with excel files it says fast copy is not supported please help me with an answer. TIA
@ehtishamnaseer93062 ай бұрын
can you please share template with data plugged in.
@abhayverma-xm7kg2 ай бұрын
Hi there, can you please share your script for us to learn, evaluate and run?
@adrienpuledda37373 ай бұрын
I am trying to reproduce this, but i don't have to create a category table, my categories is a dimension that already exists -> Region I am trying to create a waterfall to explain how the Delta Actual 2024 to Budget 2024 breakdowns by regions. As measures I have : Sales 2024 Budget 2024 Delta = Sales - Budget As dimension I have : Region could you help me?
@adrienpuledda37373 ай бұрын
Actually I used my brain and Managed : Delta = Switch(selectedvalue(Waterfall[Walksort]), 1, Switch(SELECTEDVALUE('MD IMP Customer (Sales View)'[Region]), "EMEA",-1*[Delta to Budget 2024 abs.], "APAC",-1*[Delta to Budget 2024 abs.], "North America",-1*[Delta to Budget 2024 abs.], "LATAM",-1*[Delta to Budget 2024 abs.], [Budget Sales 2024 CHF] ), 2, Switch(Selectedvalue('MD IMP Customer (Sales View)'[Region]), "EMEA",0, "APAC",0, "North America",0, "LATAM",0, [Actual Sales CHF 2024] ) ) Thanks a lot for your video
@u2havenosoul3 ай бұрын
Thank you for this video, it helped me with my charts, but do you know how I can manually sort the x axis? I noticed that the declines are always on the right hand side and I want my x axis to be manually sorted
@mikebeccaria3 ай бұрын
This is great. I'm wondering if it is possible to also generate a YTD measure that calculated the cumulative sum of the forecast measure so companies can determine if they will meet their end of year targets based on the forecast. I've been trying but keep running into issues and errors. Any suggestions?
@rauljimenez54853 ай бұрын
what I have done for this is to create a measure that uses SUMX over the values of the future weeks (or months, depending on the granularity of your analysis) up to end of year. That will give you the cumulative total of the forecast. Hope this makes sense
@mszakalinski3 ай бұрын
thing is when i change the values the soting is always from top breakdown to bottom by value how to avoid that? like breakdown A=100 is always before (to the left) breakdown B=50 i would like them to have places on axis i choose
@gustavodesouzahochleitnerl18243 ай бұрын
Hello, ty for your video. But I already saw the impacts calculate by another form. Instead consider Price and Volume LY, they consider TY. Like this: Price Impact = Delta P x Vty Volume Impact = Delta V x Pty Mix Impact = - Delta P x Delta V Do you know why? And there is another way to calculate the mix imapact and volume impact that I didnt understand very well, do you know this form? Mix impact = ((Volume Unit. TY / Volume Total TY) - (Volume Unit. LY / Volume Total lY)) x (Price Unit LY - Avarege Total Price LY) x Volume Unit TY please help me.
@Curic-Ivan3 ай бұрын
Best video on this topic on YT!
@satellitepop3 ай бұрын
Hello, I am currently one of the owners of a subscription, I created a Fabric Capacity in Azure, I started the capacity in a new Workspace. However, after uploading folders to my Lakehouse, I noticed that ""Manage Data Access"" option does not appear. Am I doing something wrong, or should I enable something that I don't know?
@carloscantu753 ай бұрын
This was very helpful; I appreciate the point of view of a seasoned developer such as you.
@jugalshah76553 ай бұрын
Can you share the calculations used to determine cost impact?
@OhAdamTV3 ай бұрын
Thanks for the video I keep seeing references to direct lake "automatically refreshing when the data changes" Can the Direct Lake connection mode replace Direct Query for live/real-time data reporting? Or are these updates only visible when hitting the refresh button/reloading the report/webpage?
@simomoforever3 ай бұрын
so the query to PBI semantic model is essentially SQL query to tables, how about the measure, calculation, relationships between tables, and the metadata?
@TSmitty3603 ай бұрын
Is the GO button necessary? Anyway to do this with just one click each time?
@rswilso3 ай бұрын
Much appreciated. I’m running into an issue where the sequence of the market basket is not always the same despite containing the same products. For example 243-345 vs 345-243. I tried to add a sort step on Product ID in power query but does not seem to remedy the DAX Logic. Any thoughts on how to output a consistent market basket sequence would be appreciated.
@ollie31774 ай бұрын
Well done for finding the solution and thank you for sharing it. Could you please explain why it is so tricky and how did you find that out?
@JudyAnnGabayno4 ай бұрын
Great video! Would it be possible to get the PBIX file you used? I'd love to explore it further!
@Babayagaom3 ай бұрын
Try yourself.
@zxccxz1644 ай бұрын
this is nice, learned this a few years back. perhaps you can add to this the positives and negatives of continuous vs categorical. and does it matter if you use start or end of month? i use end. And is there user education needed when you hover over data points? I struggle with making dynamic charts that will correspond to the date range selected. ie I have book marks for All Years, CY , CY-1, Last Month Current Month, Last 10 days. Each trys to display chart and matrix for that matter in correct manner. ie Last 10 days, CM and LM drill down to day level. All Years show continuous, CY shows my month
@Nalaka-Wanniarachchi4 ай бұрын
Nice video.I assume page and page navigation tables are disconnected tables which control the behaviour of page navigation and not filtering the data.
@AjharAhmed-wt9kf4 ай бұрын
DO YOU NEED SEO EXPERT FOR YOUR CHANNEL IT WILL HELP YOU TO GROW YOUR CHANNLE
@bschuss14 ай бұрын
One thing to be aware of as well: on small capacities you are very limited in concurrent spark sessions, so a long running notebook will block other notebooks or Lakehouses.