***** Related Links ***** How To Create A Dynamic Power BI Report blog.enterprisedna.co/create-an-entirely-dynamic-report-in-power-bi/ Data Visualization Technique In Power BI - Multi Measure Dynamic Visuals blog.enterprisedna.co/how-to-create-multi-measure-dynamic-visuals-data-viz-technique-in-power-bi/ Using Filter Fields & Visual Interactions To Create Compelling Visualizations In Power BI kzbin.info/www/bejne/mpqoaI1mmdSKkNk ***** Related Course Modules ***** Data Visualization Tips portal.enterprisedna.co/p/data-visualization-tips Dashboarding & Data Visualization Intensive portal.enterprisedna.co/p/dashboarding-and-data-visualisation-intensive Mastering DAX Calculations portal.enterprisedna.co/p/mastering-dax-calculations ***** Related Support Forums ***** Multi Day Analysis Not Working forum.enterprisedna.co/t/multi-day-analysis-not-working/887 Monthly Report With Dynamic Month Names forum.enterprisedna.co/t/monthly-report-with-dynamic-month-names/1468 How Can I Retrieve A Value From A Virtual Table And Place In Each Row Of Report forum.enterprisedna.co/t/how-can-i-retrieve-a-value-from-a-virtual-table-and-place-in-each-row-of-report/1567 For more dynamic report queries to review see here….. forum.enterprisedna.co/search?q=dynamic%20report
@TinaCSSSS5 жыл бұрын
Hi, I tried the same with my data and since the dataset is old, I put MAX date instead of TODAY() and it's not working :(, everything else stayed the same...any idea why my table isn't dynamically changing? Slicer works when I show on the card the value, but it doesn't affect my table anyhow... Total Revenue = CALCULATE([Total Sales], FILTER( sales, sales[dateSold] > ([Max Date] - 'Days Range Selection'[Days Range]) && (sales[dateSold]
@juliantagell18915 жыл бұрын
It might be your [Max Date] calculation. I used MAX DATE = CALCULATE(MAX(Dates[Date]), ALL(Dates))
@saraiaccheo45754 жыл бұрын
Just wanted to say thank you! I was trying figure out all week how to build a dynamic report in Power BI, and this video as well as the respecting web explanation helped me so so much! THANKS, this really can make power BI a much more efficient tool.
@ajaaskelainen5 жыл бұрын
Thank you! I especially loved the switch( true() .. example in the end!
@EnterpriseDNA7 жыл бұрын
Appreciate the feedback. Thanks
@Medhat_Ragab4 жыл бұрын
Thank you very much.. You are simple and amazing because you really understand DAX in depth 🌹
@EnterpriseDNA4 жыл бұрын
I appreciate that!
@TheBlackdekker7 жыл бұрын
Great Video Sam. Very useful technique. Definitely thinking about uses for it! Love your videos! Probably the most useful and easy to follow videos I've found.
@EnterpriseDNA7 жыл бұрын
Thanks Alan
@LotfyKozman7 жыл бұрын
Very helpful and awesome video. Thanks for your efforts.
@thaidude8905 жыл бұрын
Thank you very much. I think I found the way to compare sales between 2 selected period of time.
@myfriendscallmeturk75684 жыл бұрын
Your videos are great....would be even better if you moved your microphone off of the surface that you are typing on. Thanks for all the amazing tutorials!
@npmnpm55017 жыл бұрын
This is one of the best training videos on DAX I have watched!!!
@EnterpriseDNA7 жыл бұрын
Great to hear
@marklund74986 жыл бұрын
Awesome video, really useful technique and super clear as always. Many thanks Sam!
@sokgat70197 жыл бұрын
Great, as always!!! Thank you very much!!!!
@chanleaknahang58167 жыл бұрын
Amazing , finally i found what i'm looking for. You're awesome. Please keep it up. keep tutorial advance VDO
@abhijeetghosh275 жыл бұрын
I liked this video tutorial.. thanks ! Can you please suggest, how to add static values in rows for each category. I can share the pbix file if required.
@hi_vishy6 жыл бұрын
Great video. I have a slightly different requirement. Unlike in your case where you select either Revenue or Profit, what if I select both and want to see two separate columns in the table at the same time. What do I need to do?
@EnterpriseDNA6 жыл бұрын
Then you wouldn't really want to use this technique. You would just have each specific measure in the table
@mariatorre616 жыл бұрын
Hi Sam, Thanks very much! Abraço Portugal
@phatboyblonde6 жыл бұрын
Is it possible to have different formats based on metric selection? Example: revenue in $ and sales volume as whole number?
@EnterpriseDNA6 жыл бұрын
Unfortunately no at the moment. That is the one big restriction. So need to work around that.
@TheBlackdekker7 жыл бұрын
Really like all of this. Hopefully I can use this. Where do I get the example data that you are using?
@EnterpriseDNA7 жыл бұрын
Great, there will be plenty of opportunities to use this or derivative of this technique. This download can actually be found here - enterprisedna.co/power-bi-resources
@likz11544 жыл бұрын
@Sam , Thanks for brilliant technique , i tried implementing same logic in the PBI file downloaded from Enterprise DNA ..no change in source , stuck with dax code of total revenue based on slicer selection of days , its not returning any output to the table visual , no change in dax code , somehow its not providing any result its showing up blank Total Revenue = CALCULATE( [Revenue], FILTER( Dates, Dates[Date] > TODAY() - [Total Days] && Dates[Date]
@navaneethkings4 жыл бұрын
i'm also getting no output and no errors too
@likz11544 жыл бұрын
@@navaneethkings its because of the old data set used...when you are using today function ..its looking for current day data ..instead use the max date ..or any hardcoded date ...i figured out the issue later
@automationguide34987 жыл бұрын
Thank You !!
@MuhammetMustafaAslan7 жыл бұрын
Hi Sam, Thanks very much, it's a great video...
@victord91595 жыл бұрын
I see you everywhere buddy
@frankgovers84207 жыл бұрын
Hi sam, do you think it is also possible to change the text : metric selection result, as header in the table , to profit or sales??
@EnterpriseDNA6 жыл бұрын
Sure absolutely, easy fix
@frankgovers84206 жыл бұрын
Also , simple explain how in a new video??
@KyleRichter233 жыл бұрын
Sam, I absolutely love your videos, but a lot of low sound end comes through on your microphone, mainly when you’re typing on your keyboard. When you type, my Bose sub shakes my window like I’m watching a movie.
@EnterpriseDNA3 жыл бұрын
Hi Kyle Richter, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA