Power BI Native Progress Bar | Create Progress Bars Without Custom Visual or SVG in Power BI
Вставка
- Опубліковано 11 вер 2024
- We will Use some DAX Tricks to enable Progress Bar using Power BI Line charts. This technique is helpful in case you are not allowed to use custom visuals in your organization.
Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
/ power-bi-helpline-22a2...
Email- info@pbihelpline.com
@PowerBIHelpline
Just amazing...🎉🎉
There is no doubt that one day you will be the leader in youtube for power bi contain.
Wow! Thank you so much for showing such a great confidence and interest in our contents.
wow, it was truly out of the box thinking example 🤜
Glad to see, this solution is so useful.
One word: AMAZING
Thanks for watching.
What a great lesson, thx!
Glad you liked it!
Bravo. You are so great and thanks for the sharing.
Thank you! Cheers!
Amazing tutorial
Thank you! Cheers!
Incredible video, simply the best on the internet.
I repeat your steps, however my "Data Point" does not appear on the graph, could you help me with a solution?
Thanks for the appreciations. If you want to get the PBIX file, send an email to info@pbihelpline.com with video title as email subject.
@@PowerBIHelpline I sent you my email
@@guilhermebastos5685 same here, no data point in visual and also 3rd slab is not shown
Where is the budget utilization % coming from? I tried to bring in a different data set as it seems like this was done but in the formula I cant access that value
Very good details view project
Glad you like it!
Excellent 🎉 thanks for sharing
Thank you! Cheers!
How to add CF for this i want data bar to be green until it reaches the target and beyond that to be red. How to do it?
Great tricks. But there is one problem, in this visual we are setting up the target at 80%. If we use this visual as target performance analysis, there will be a confusion.
If the target achievement is greater than 80% but less than 100% (let say 91%), the data point indicates that we are achieving (achievements is greater than the target line) even though we don't.
How to overcome that problem?
I found a way. I just make the axis line longer than 100% (say 150%) and then set the target to 100%
Thanks for sharing, However my data point is not visible.
I can understand that if you miss any part of the formatting, you would not get the required functionality. Please make sure you haven't missed any step. if required, you can send an email to get the PBIX file used in the demo
IF( MAX('Progress Bar'[Axis])=ROUND([Budget Utilization %],2),17,BLANK())
You're welcome
Thanks, I had to apply this as well.@@sanskar21
Thanks for sharing. I can't find the error bar section. I am using PBI version from Nov 2023
same here
It is not in the visuals or format section, the bar error is in that magnifying glass
section. Look it up, I found mine after a while
Will it work for targets and if target achieved is more than 100%
Yes, you can adjust the measures accordingly
Can we do this just to share milestone in dates format ?
Yes you can.
Very creative, but DAX and audio explanations are too fast to grab and understand. I have to rewind several times to get the concept. Anyway, great video.
Great suggestion! Thanks for providing your valuable input.
Great video. Can you share the file
To get the PBIX file used in the demo, you can send an email by mentioning the video title as email subject
Please share the file use.. email sent thank you
You are going too fast