Hi Donatella, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hi Linda, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Really nice! I love visualization tricks that actually make the report more impactful and readable (instead of just flashy and gimmicky). Hope you'll share more of these possibilities 🧠
Hi G.H. van den berg, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Hi Gergely Földi, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Hi darryl morgan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Hi Myexcelacademy, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Hi Tim Truax, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Hi Mohammed Suleiman, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Thanks for this helpful video. Is it possible to do this with a box and whisker chart? There aren't any PowerBI default Box and Whisker visualisations which may make this a bit more tricky.
Hello Marcus, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, you can create a custom chart either by using "Deneb Vega-Lite" or "Charticulator" based on your preference. Our Enterprise DNA Experts have created courses on both of these tools and have created a showcase as well. Below is the link of the courses as well as of showcase provided for the reference. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Subscribe to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ portal.enterprisedna.co/courses/enrolled/1816839 portal.enterprisedna.co/courses/enrolled/1343267 forum.enterprisedna.co/c/deneb-showcase/58
Hi Alex. Very useful trick, Thanks. When I use you trick some of the dots are hidden behind other un-highlighted dots due to the density. Is there a way to bring these selected to the front or something?
Hello Lars, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it and we're glad that you liked our content. Well, you can highlight the dominant dot with the very bright color and other dots with the very light color or you can only fill the dominant dot with the color and leave other dots with no fills but only outline. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@@EnterpriseDNA To solve this I made the unfiltered dots transparent so the dots I wanted highlighted shone through. Its easy to do, use the rgba(x,y,z,a) in place of the colour code. rgba stands for Red, Green, Blue, Alpha. Alpha is the transparency, I have mine set to 0.15. Red, Green and Blue are integers which make up the colour code you originally input from this video.
Hello Richard Oliver, thank you for posting your query onto our channel. Well no, this is not possible using one slicer and by modifying the DAX. The logic behind the use of two slicers is that, if selected value in the first slicer matches with the value of the newly created slicer than the color in the chart should be different for that selected value and the values which are not selected into the first slicer should portray the normal color into the chart. For furthermore queries, you can also reach out to our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping this explanation helps you to clear the doubt that you've pertaining to the technique showcased into the video. Happy Learning!!! forum.enterprisedna.co/
but this does not apply to category labels. when i am selecting a value from first slicer then chart is showing me labels for all values instead of showing label for only selected value. can you help?
Hello Sanket, Thank You for posting your query onto our channel. Well as showcased into the video that if you don't want the slicer affecting your visuals then in that case one can turn off the "Edit Interactions" option. In your case, you can activate the edit interactions option and once it's activated you'll observe that slicer will have an effect on the category labels as well and it'll show only those values that are selected into the slicer. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Also, please make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
@@EnterpriseDNA I have some examples below of FPY (First Pass Yield): Example 1: Item 0001 - Received Item 0002 - Received Item 0002 - Problem found after Received (LINE above) FPY = 50% On Google are Some examples like that, but I don't know how to do It. On RUclips there is no video explain FPY.
Hi Yilin thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks! portal.enterprisedna.co/
Hi Alex very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Great work.
That's one of the best trick I have seen in Power BI.. Thanks a lot for sharing this with the Power BI community.
Amazing work finding this trick! Thanks for sharing
Hi Donatella, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Love it! Great solution - thanks for sharing
Hi Linda, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
@@EnterpriseDNA Don't worry - I'm subscribed!
Congrats on your first video. Off to an awesome start!
Amazing trick Alex 👌👏
Thanks for the continued support, Hossein!
Thanks very much. This feature was desperately needed in Power BI
Hi tottihope tottihope, glad you appreciated the video. We are so grateful to have had such positive feedback.
Really nice! I love visualization tricks that actually make the report more impactful and readable (instead of just flashy and gimmicky). Hope you'll share more of these possibilities 🧠
Hi G.H. van den berg, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Great hack but in the same time very elegant solution! Thanks for sharing
Hi Gergely Földi, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Really Nice Technique Thumbs Up...Thank You Alex
Hi darryl morgan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Bravo, well done Alex
Hi Myexcelacademy, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Great video. Can also use this conditional formatting for the names of the X-axis or Y-axis? Thanks
This is cool. How about adjusting the size of a marker based on the selection of the Slicer?
Amazing work Alex. Welcome to content creation on the channel!
Nice work!!
Hi Tim Truax, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Thank you, amazing
Hi Mohammed Suleiman, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Thanks for this helpful video. Is it possible to do this with a box and whisker chart? There aren't any PowerBI default Box and Whisker visualisations which may make this a bit more tricky.
Hello Marcus,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well, you can create a custom chart either by using "Deneb Vega-Lite" or "Charticulator" based on your preference. Our Enterprise DNA Experts have created courses on both of these tools and have created a showcase as well. Below is the link of the courses as well as of showcase provided for the reference.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Subscribe to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/
portal.enterprisedna.co/courses/enrolled/1816839
portal.enterprisedna.co/courses/enrolled/1343267
forum.enterprisedna.co/c/deneb-showcase/58
Hi Alex. Very useful trick, Thanks. When I use you trick some of the dots are hidden behind other un-highlighted dots due to the density. Is there a way to bring these selected to the front or something?
Hello Lars,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it and we're glad that you liked our content.
Well, you can highlight the dominant dot with the very bright color and other dots with the very light color or you can only fill the dominant dot with the color and leave other dots with no fills but only outline.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/
@@EnterpriseDNA To solve this I made the unfiltered dots transparent so the dots I wanted highlighted shone through. Its easy to do, use the rgba(x,y,z,a) in place of the colour code. rgba stands for Red, Green, Blue, Alpha. Alpha is the transparency, I have mine set to 0.15. Red, Green and Blue are integers which make up the colour code you originally input from this video.
Could this be achieved with just one slicer (and amending the DAX)? I follow the DAX, but not what the second slicer is there for.
Hello Richard Oliver,
thank you for posting your query onto our channel.
Well no, this is not possible using one slicer and by modifying the DAX. The logic behind the use of two slicers is that, if selected value in the first slicer matches with the value of the newly created slicer than the color in the chart should be different for that selected value and the values which are not selected into the first slicer should portray the normal color into the chart.
For furthermore queries, you can also reach out to our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping this explanation helps you to clear the doubt that you've pertaining to the technique showcased into the video.
Happy Learning!!!
forum.enterprisedna.co/
but this does not apply to category labels. when i am selecting a value from first slicer then chart is showing me labels for all values instead of showing label for only selected value. can you help?
Hello Sanket,
Thank You for posting your query onto our channel.
Well as showcased into the video that if you don't want the slicer affecting your visuals then in that case one can turn off the "Edit Interactions" option. In your case, you can activate the edit interactions option and once it's activated you'll observe that slicer will have an effect on the category labels as well and it'll show only those values that are selected into the slicer.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for. Also, please make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Hello!
Your video is very nice. Can you create a video explaining how to creating a "First Pass Yield (FPY)" chart?
Hi Wendy Santos, appreciate the suggestion. We will put this on our list.
@@EnterpriseDNA Thanks a lot!
@@EnterpriseDNA I have some examples below of FPY (First Pass Yield):
Example 1:
Item 0001 - Received
Item 0002 - Received
Item 0002 - Problem found after Received (LINE above)
FPY = 50%
On Google are Some examples like that, but I don't know how to do It. On RUclips there is no video explain FPY.
Maybe a silly question. Would you mind sharing how you created those scatter charts? what is the X-Axis and how to avoid using Legend?
Hi Yilin thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks!
portal.enterprisedna.co/
Hi Alex
very useful video and very practical need everyone for every project ......very big thanks to share with us.
If it can possible can you plzz provide us excel data file which you used.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Hi ashish mohan, appreciate the suggestion. We will put this on our list.