วีดีโอ

Hello could you make a video of dax function Filter and All in detail. When to use them together while calculating measures !!❤

I just implement this features in my sales report! Thanks for sharing!!

So you did the background in Power Point? I really thought you used a designing software!

I just star watching all your videos and let me tell you sir! That I really enjoyed a lot every one of them! Like the maven analytics challenge you have solved! A must see video for everyone who wanna learn good and personalized visuals 👌🏼👌🏼👌🏼👌🏼👌🏼

Very inspiring. Thanks for your time.

A gem among the YT videos! The only item I found difficult to locate was the line used across the column. In my PBI desktop I had to click on the magnifying glass which is the third icon above the options and search for "line" then constant line appeared. Afterwards including the measurement I wanted as a conditional formatting did the trick. Thank you so much for this wonderful KPI tool that is far superior than the included gauge. I've used it to track a number of items as a percentage indicating health of a part of my program. The only trick I'd suggest to the other nascent data visualization fans is to use ChatGPT to write a dax formula Table = x Column = x I need a dynamic measure of that by (whatever you need say in the last 12 months etc) Thank you Gerard for a great video!

It is kind of silly that a very common type of measure doesn't come out of the box

This is great video and learned on KPI dashboard. I have got a slightly different KPI dashboard, can you advise how to do it? similar to the details you mentioned category, definition, target and previous three months numbers for each KPI. How do I make relationship from this static table to invoice table to retrieve monthly information against these metrics?

very cool, just used it in my P&L report

Hi I have doubts about the slicer is this possible to when we select any category in the slicer then the slicer pop up does not disappear automatically when we have to click any other place then the slicer pop up disappear. Any solution i want when we click on the category in slicer then the slicer pop up automatically disappears.

How does even find that thing with the markers color lol it was such a neat discovery

Amazing way to display KPI. Thank you for sharing

my if and does not work

Very awesome technique, Thank you so much.

Thanks Gerard! Great Tutorial keep uploading!

Underrated Gem 💎

excelent!!

nice explantion

Love it!

Any clarification on how i copy across the measures for each column

crazy guy...fantastic!

Really a nice one❤

Gerard looks and sounds very similar to Jason Isaacs. So all this video is pretty much Lucius Malfoy explaining you some Power BI

Hello Sir, When to combine ALL function with Calculate + Filter function in DAX in detail ? Please make a video of it 🙏 ❤

Great Video. Thank You Dear Gerard.

Promo>SM

Such a great method. I was thinking how could I achieve measuring customer flow in a span of 1h and always felt that I was missing something. Thank you Gerard!

Fantastic work. Learned so much from the hack. Your explanation and simplicity of writing the DAX measures really made me understand a lot. Kudos. Looking forward to learning more from you. Would be applying this on a live project in the coming days.

Amazing way to display KPI. Thank you for sharing

Really thank you!!!!!!

Unpivot!!! Did use it once a hundred years ago, but I really didn't remember it. You are a hero! Thanks!!!

Thank you so much for such a useful video! Allowed our company to skip purchasing likert scale visual subscription.

thank you so much, you helped me alot

Thank you for sharing! On the last method, I could not get my % at the bottom to start with 0. I also only had negative, unsure, and positive.

Hi Gerard, what is your design inspiration?

I cant find the excel file used for this class. Would be great to practice along with him.

love this kpi hack!! Out of curiosity - what canvas size do you use? I’m having a hard time fitting everything using 16:9

Hi, Thank you for the video Had a doubt here your are only comparing end of month... What if I had to select the daterange that the user has selected in slicer maybe 2 weeks and based on that show the trend by comparing it with the previous 2 weeks...

Hi Gerard, I Love the insight, I had a challenge of not copying and pasting it.

Have gone back to this video again and again these last few months. Very informative. Very helpful. Sometimes your voice fades so I think you have a tendency to be soft spoken :). But one of the best, if not the best step-by-step walkthroughs for making a divergent Likert scale. 'Appreciate the fact that it brings together all the arguments on how best to visualize this kind of data. Thank you very much! :)

Amazing Video, I followed you step by step and it really helped me build a Multi KPI Dashboard. Thank you so much!

Which bubble chart are you using for this data

Great one! Have you tried making it with Dax?

May I know the color scheme for your pbi?

Audio is very low for me to hear.

Not sure if it was just me, but found the audio a little quiet.

Amazing!

Thanks Mr. Duggan. It's a great video

Wow, this is impressive. Thank you.

Are we keeping the missing values? Or removing them?