Seleha Shaikh

Control the visibility of the PowerBI visuals based on condition

/in , , , , /by

In PowerBI, there is no direct or functional mechanism to adjust the visibility (Show/Hide) of visualizations based on filter choices. There is, however, a workaround that enables us to show/hide visuals based on filter condition.

The fundamental concept behind this technique is to apply a mask to a visual and change its opacity based on a condition or filter selection.

Use Case:

I have detail table of orders. These orders are divided into Consumer, Home Office, and Corporation categories. I use segment as a filter. One of the requirements is to present a table of detail if the overall profit for the selected segment is less than $100,000. To do this, this task will be divided into two major parts. First, we will display the table if the filter is selected. Next, we will add a condition to the table.

Step 1: Show table only filter is selected

  • Place filter (Slicer) and visual on the Report Pane.

  • Create a measure that will determine if the filter is selected or not.

Filter_Selected = IF(ISFILTERED(Orders[Segment]),1,0)

  • Add this measure to the filter pane of the table visualization and select the show item when the value is 1 option. This will ensure that when no options are selected, only the header is displayed.

  • Set the mask down on the table. Make sure you only mask the table header with a border color that matches your background, or remove it entirely.

  • Create a measure to change the mask’s transparency. If two zeros are appended to the end of any HAX code, this represents complete transparency.

mask_transparency =IF([Filter_Selected],”#FFFFFF00″,”#FFFFFF”)

  • Keep this measure on the Fill of the mask and add conditional formatting to it.

If the mask transparency(measure) field is grayed out during the previous steps, you may need to modify the data type of mask transparency to text.

Step 2 : Add a condition to the solution

  • Create a new measure to determine if our condition is met.

condition_check = IF(CALCULATE(SUM(Orders[Profit]),filter(all(Orders), Orders[Segment] = SELECTEDVALUE(Orders[Segment]))) < 100000,1,0)

  • Now add this new measure to a table visual’s filter pane and pick the show item when the value is 1 option. This ensures that only if the condition meets the table will appear.

You can now display or hide visuals based on slicer selection and condition. If you know a better way to do this, please comment and let me know. For this article, I referred to this page.

 

Ariaa Reeds

Data Science Certifications to Excel in Your Career: A Holistic Approach

/in , , /by

Personal and professional growth for an individual depends on the investment one puts in continued education. Continued education is necessary for leadership positions and industries such as human resources, manufacturing, marketing, operations, information technology, etc. Staying updated with the relevant profession is essential to move up the career ladder, and in certain cases, it is essential to save the job. 

It showcases your knowledge, education, and relevant skills necessary to perform the job for the current and future employers. ‘Career growth’ is not defined by the higher salaries but the effort made to earn those ‘higher salaries.’ Higher salaries do not mean the appreciable yearly increment in a well-established firm but earning the competent salaries by staying with the trend. We will discuss the learning opportunities for the most in-demand data science professionals here. 

 

Data Science certifications for the Newbies

When you understand the basic principles of data science, it would help you use the tools productively. If you are looking to develop data analytic skills, then you can opt for certain free online courses. It helps you learn the basics of data science at your own pace and get acquainted with the field knowledge.  

Most of the data science certification program or courses mentioned below are available free online. Though, a few may charge for gaining the certification once you finish the course. Whatever the case may be, you get destined to gain knowledge in the field which would be a good kick start for your career. 

To mention a few, they are:

  • Coursera – Data Science Specialization
  • Edx – Data Science Essentials
  • Udacity – Introduction to Machine Learning
  • IBM – Data Science Fundamentals
  • Data Quest – Become a Data Scientist
  • Kdnuggets – Data Mining Course

Most of these courses are available free online and are self-paced. You can get the basic hold of the subject and afterward, you may go for premium courses to advance learning or earn certifications.  

 

Data Science Certifications for Professionals

To stay competitive in the industry, you should get certified from industry-renowned global certification bodies. Mention not to say, there is a lot of difference between courses and certifications. Though a course gives you the relevant subject knowledge or skill, a certification program is vendor-neutral and increases your employability factor. It equips you with the latest tools and techniques and assures your prospective recruiter that you are their shot to hire. 

To mention a few of the best data science certifications, they are:

  • SAS Academy for Data Science – SAS Certified Data Scientist
  • Data Science Council of America (DASCA) – Senior Data Scientist 
  • Google- Google Certified Professional Data Engineer
  • Dell EMC Education Services– Data Science Associate v2 (DCS-DS) certification and the Data Science Specialist (DCS-DS) certification

These certifications equip you with the latest tools and techniques and assure your prospective recruiter that you are their shot to hire. 

 

Industry-specific Certifications

Industry-specific certifications, as the name itself indicates, these are specific to the industries. These certifications provide you specific training with use cases in the industry you are interested in or working. It helps you solve industrial problems at a faster rate with deep insight.  

To mention a few:

  • Agriculture Industry- Certificate in Agricultural Data Science
  • Fintech industry- Certification course for financial professions
  • Business Analytics – Harvard Business School’s Certification Program 

The data collected by an education department is entirely different from the e-commerce industry. These certifications give you a clear-cut idea about data mining and deriving insights by using the right and specific tools as required.

 

Cross-functional Certifications

A data science job is an end-to-end job. Data insights are used to improve business productivity, marketing strategy, and business value. So, it is good to know other fields also like business analytics, marketing, manufacturing. Though these certifications do not directly deal with the subject, it structures your knowledge base in the industry. It gives a holistic approach to your work and widens your organizational value. 

To mention a few, they are:

  • Project Management Institute- Project Management Professional Certification
  • Springboard – Certified UX Designer
  • Business Analyst Professional Program – Institute of Business Analyst Training

These certifications give you complete knowledge of the system and help you derive data with a holistic approach and gain business benefits. 

 

Wrapping Up:

In addition to certifications, it is necessary to complete a few independent projects to showcase your skills. It increases practical knowledge and provides hand-on-experience in technology. Ultimately, the knowledge we impart for the organization that can increase value matters. 

So, rather than choosing certifications or learnings merely for job or salary purposes, it is recommended to choose for learning purposes. When you develop interest and dedication for the subject, it helps you go a long way in the career path. 

Be strategic in your learnings and increase the knowledge base.