I have a question… When trying to add New Measure to calculate Target vs Actual, after typing = DIVIDE( , nothing pops by for me to select, even if I manually enter [ . This happens from time to time, any reason why….? Thanks for advice! 🙏🏻
Hi, thank you for this. Was very helpful. If you don’t mind can you share the hex code for that nice purple colour from the very beginning of the video?
Thank you! I spent a day trying to figure out how to complete such a simple task. It was the % remaining with the max( negative) that I was missing. Also needed to the if statement for above target to switch… to make it completely understandable for the user when % remained or % was above target. Thank you so much!
This is exactly what I'm looking for, but how to calculate this if there are date-wise records for each segment (how to add them) and I have Monthly and Quarterly targets?
This is great. Thank you. Do you have a video that shows how to achieve a Stepper progress bar ? I would like to illustrate where a project is (which stage). I have a column that has the stage name. Stages are predetermined and follow a certain order. Stage 1 > Stage 2 > Stage 3 > Stage 4. The idea would be to show this kind of visual on a details page (drill down).
Thanks 🙏 For your requirement, Funnel chart should work as it isn’t cable of showing progress by stage and the conversion Please try and share your feedback It can also show both the value and the percentage
not working in my data. as achieved and remaining percentage in 100%stacked Bar showing their individual achieved and remaining % i stacked Colum. resulted in 4 data values in bar. how to solve this problem.
Thanks for watching ! The measure for remaining % is: MAX( - [Actual vs Target %] , 0 ) I used minus to switch negative and positive results from Act vs Target and compare with zero and pick MAX number. If the target is not achieved yet, the negative result will switch to positive and vice versa. Please download the PBIX file study further.
Incredible, your way of explaining is fantastic, very clear and easy to follow, this is the meaning of professionalism thanks a bunch
Very easy-to-follow guide. Thanks a million times for this.
Thanks 🙏
For The table on the right, what front or table style do you choose? It look simply but so clear. Friend .Thank it
This is exactly what I want! Thanks alot for the inspiration!
I have a question… When trying to add New Measure to calculate Target vs Actual, after typing = DIVIDE( , nothing pops by for me to select, even if I manually enter [ . This happens from time to time, any reason why….? Thanks for advice! 🙏🏻
Sometimes the intellisense stops working, close and and open the file, that works
Hi, thank you for this. Was very helpful. If you don’t mind can you share the hex code for that nice purple colour from the very beginning of the video?
Glad it was helpful!
Here is the hex code: 744ec2
@@ExcelFort thank you ☺️
Very nice. That's what I exactly looking for. Please make more videos. Thanks.
Thanks! Sure more video will be released
Great content!! Thanks for share useful idea.
You are welcome 🙏
Share the channel with your colleagues and friends, let others too benefit.
Thank you very much!
Thanks 🙏
Thank you! I spent a day trying to figure out how to complete such a simple task. It was the % remaining with the max( negative) that I was missing. Also needed to the if statement for above target to switch… to make it completely understandable for the user when % remained or % was above target. Thank you so much!
Happy hear it was helpful to you.
Not sure if you are trying to ask a question 🙋
Please clarify and provide more details
Thanks for sharing. Very interesting.
Glad you enjoyed it
Very, very useful! Exactly what I needed to get started on my dashboard. Thank you!
Glad it’s useful
Hi while I am trying to create Achieved measure, getting an error stating that Min function only accepts column reference, any work around for this ?
this was great, thanks much appreciated
Glad it was helpful!
great explanation!
Excellent reply in my reports, I thank you very much
Thank you too!
thanks very useful
You are welcome
Thanks Sir very helpful
Like 👍 Subscribe and share :)
Wow! Many thanks
Most welcome
Love you man your videos is really useful and very understandable, MJ from Saudi Arabia ,keep it up 🌹👍🏻
Glad you like them!
thanks for the video)
You are welcome!
Very informative 👏thanks
It’s my pleasure:D
Incredible
Thank you
A fantastic learning video and sure is helpful for dashboarding. This will be great getting the PBIX file. Thanks.
Thanks! If you haven’t downloaded the file, find the link in the description.
@@ExcelFort thanks a lot. Apologies, didn't notice it was there.
Thank you so much
You're most welcome
Excellent
Thanks 🙏
This is exactly what I'm looking for, but how to calculate this if there are date-wise records for each segment (how to add them) and I have Monthly and Quarterly targets?
amazing technique, please make more videos
Thank you, I will
This is great. Thank you. Do you have a video that shows how to achieve a Stepper progress bar ?
I would like to illustrate where a project is (which stage). I have a column that has the stage name. Stages are predetermined and follow a certain order. Stage 1 > Stage 2 > Stage 3 > Stage 4.
The idea would be to show this kind of visual on a details page (drill down).
Thanks 🙏
For your requirement, Funnel chart should work as it isn’t cable of showing progress by stage and the conversion
Please try and share your feedback
It can also show both the value and the percentage
Great stuff!! Please make more videos on look and feel/ formatting please
You are welcome 🙏
I am planning add more similar videos, stay tuned.
Share the channel with your colleagues and friends, let others too benefit.
Awesome Sir
Thanks a lot
not working in my data. as achieved and remaining percentage in 100%stacked Bar showing their individual achieved and remaining % i stacked Colum. resulted in 4 data values in bar. how to solve this problem.
can share page setting please
Sorry, can you explain?
@@ExcelFort sorry sir actually i was asking about your page background settings, i guess you used shape
Très bien. Merci infiniment
how have you added the remaining percentage please? not sure how to calculate in BI
Thanks for watching !
The measure for remaining % is: MAX( - [Actual vs Target %] , 0 )
I used minus to switch negative and positive results from Act vs Target and compare with zero and pick MAX number. If the target is not achieved yet, the negative result will switch to positive and vice versa.
Please download the PBIX file study further.
can u make it overlapp? like 125%?
Yes, that's possible by using a workaround with two charts for the bar chart.
Crack, wonderful Video!
Glad you enjoyed it
Excellent sir
So nice of you
Can you share the data file for follow along😕
Hi
It’s in the video description
Awesome
You are welcome
Great Work, anyone Can send me PBIX File for this video ? Please
The link is in the description
slick!
since 2 years i believe so many updates have accored to power bi and now everything is a mess in my project
Thank you very much.
You are welcome!