Видео

Great technique and a great space saver! Thanks for sharing Gerard.

it is better than most of payed courses, kinda cheated using between as data but feels better on my workplace

Great video thanks Gerard. Any reason why the reference line would not update when filter applied? I have a On Time % measure set as the Fx value for the Reference Line and for some reason does not update :( The measure in the card visual is working as expected

Could you please zoom in as you type your formulae and show the dashboard? Thank you

Subscribed. This is truly awesome!

Hi geard I have doubts about power bi suppose i have 5 tables and column names to be different for each table now output I want without append and without using bookmark and navigation. in the table visual when I put columns I want when select table name in slicer then show only those column which table i select. other wise is there any option is available in table hide blank columns. Note : All columns have text values

Thx uncle geard

Do you have a video that shows me how to do this but where I would need a column index instead of a row? So I want 5 columns and one row under the 5 columns that is populated from PBI values.

Hi, I'm struggling with the part around 31 mins where you start making the graph. I keep getting the error message "MdxScript(Model)(20,36) Calculation error in measure 'Matrix-Challenge'[Neutral count positive]: DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values". This is my code: Neutral count positive = 0.5*(CALCULATE( [Count scores], FILTER('Matrix- Challenge','Matrix- Challenge'[Likert value] = 3))) This happens with all my calculated fields except for the count scores measure. I used the code on your explanation document instead of the video one because the one in the video did not work for me. My data is very similar, I had participants rate how challenging certain tasks were from not at all challenging to extremely challenging and assigned likert values to each of them. I also wasnt able to get the Rank NPS calculation to work, I got the error "Argument '3' in ALL function is required. This is my code for that: Rank NPS = RANKX(ALL('Matrix- Challenge'[Question Short],[NPS],,DESC)) Any help would be greatly appreciated!!

❤❤❤❤ awesome man

Hey Gerard, Please Create a video of Pareto Table in Power BI using DAX

Great tutorial, thank you!

How do historical data influence CAGR calculations?

excellent man..

Do you have an updated video to do this now?

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.