Multi Threaded Dynamic Visuals in Power BI - Advanced Power BI & DAX Techniques

[@EnterpriseDNA]

***** 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

[@TinaCSSSS]

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]

[@juliantagell1891]

It might be your [Max Date] calculation. I used MAX DATE = CALCULATE(MAX(Dates[Date]), ALL(Dates))

[@saraiaccheo4575]

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.

[@ajaaskelainen]

Thank you! I especially loved the switch( true() .. example in the end!

[@EnterpriseDNA]

Appreciate the feedback. Thanks

[@Medhat_Ragab]

Thank you very much.. You are simple and amazing because you really understand DAX in depth 🌹

[@EnterpriseDNA]

I appreciate that!

[@TheBlackdekker]

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.

[@EnterpriseDNA]

Thanks Alan

[@LotfyKozman]

Very helpful and awesome video. Thanks for your efforts.

[@thaidude890]

Thank you very much. I think I found the way to compare sales between 2 selected period of time.

[@myfriendscallmeturk7568]

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!

[@npmnpm5501]

This is one of the best training videos on DAX I have watched!!!

[@EnterpriseDNA]

Great to hear

[@marklund7498]

Awesome video, really useful technique and super clear as always. Many thanks Sam!

[@sokgat7019]

Great, as always!!! Thank you very much!!!!

[@chanleaknahang5816]

Amazing , finally i found what i'm looking for. You're awesome. Please keep it up. keep tutorial advance VDO

[@abhijeetghosh27]

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_vishy]

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?

[@EnterpriseDNA]

Then you wouldn't really want to use this technique. You would just have each specific measure in the table

[@mariatorre61]

Hi Sam, Thanks very much! Abraço Portugal

[@phatboyblonde]

Is it possible to have different formats based on metric selection? Example: revenue in $ and sales volume as whole number?

[@EnterpriseDNA]

Unfortunately no at the moment. That is the one big restriction. So need to work around that.

[@TheBlackdekker]

Really like all of this. Hopefully I can use this. Where do I get the example data that you are using?

[@EnterpriseDNA]

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

[@likz1154]

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

[@navaneethkings]

i'm also getting no output and no errors too

[@likz1154]

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

[@automationguide3498]

Thank You !!

[@MuhammetMustafaAslan]

Hi Sam, Thanks very much, it's a great video...

[@victord9159]

I see you everywhere buddy

[@frankgovers8420]

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??

[@EnterpriseDNA]

Sure absolutely, easy fix

[@frankgovers8420]

Also , simple explain how in a new video??

[@KyleRichter23]

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.

[@EnterpriseDNA]

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