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!
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! 🙏🏻
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
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.
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.
![ค้างคืนโรงเก็บกระสวยอวกาศร้างกลางทะเลทราย [Around The World Ep. 3]](http://i.ytimg.com/vi/E5bWZQhABJE/mqdefault.jpg)
For The table on the right, what front or table style do you choose? It look simply but so clear. Friend .Thank it
Very easy-to-follow guide. Thanks a million times for this.
Thanks 🙏
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 ☺️
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
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
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
Very nice. That's what I exactly looking for. Please make more videos. Thanks.
Thanks! Sure more video will be released
Very, very useful! Exactly what I needed to get started on my dashboard. Thank you!
Glad it’s useful
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.
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.
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 🙏
Excellent reply in my reports, I thank you very much
Thank you too!
great explanation!
Thanks for sharing. Very interesting.
Glad you enjoyed it
this was great, thanks much appreciated
Glad it was helpful!
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 very useful
You are welcome
Thanks Sir very helpful
Like 👍 Subscribe and share :)
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
Love you man your videos is really useful and very understandable, MJ from Saudi Arabia ,keep it up 🌹👍🏻
Glad you like them!
amazing technique, please make more videos
Thank you, I will
Wow! Many thanks
Most welcome
Incredible
Thank you
Excellent
Thanks 🙏
thanks for the video)
You are welcome!
Can you share the data file for follow along😕
Hi
It’s in the video description
Great Work, anyone Can send me PBIX File for this video ? Please
The link is in the description
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
Very informative 👏thanks
It’s my pleasure:D
Très bien. Merci infiniment
Awesome Sir
Thanks a lot
Excellent sir
So nice of you
slick!
Awesome
You are welcome
Crack, wonderful Video!
Glad you enjoyed it
since 2 years i believe so many updates have accored to power bi and now everything is a mess in my project