Dynamically display tasks in Power BI

Dynamically display tasks in Power BI

Dynamically display tasks in Power BI. Tricky tasks sometimes can be solved easier than you can imagine, with little DAX magic!

A few weeks ago, I was working on a request from our Customer Support department. Essentially, the business request was to enable supervisors to dynamically filter the tasks that need to be performed.

Since supervisors also have their own tasks, they should be able to dynamically switch views between their own tasks, and tasks from all representatives.

USERNAME() & USERPRINCIPALNAME() functions

As usual, DAX offers a handy solution to your challenges. This time, I will use one of the information functions…Or to be more precise, not one, but two of them, which are very similar, but still produce different results in different environments.

Let’s start with the USERNAME() function. This function will return you the domain name and user name of the current connection. So, if I create measures like this:

My User = USERNAME()
My User Principal = USERPRINCIPALNAME()

And put it in a simple card visual, here’s what I get:

Image for post

USERPRINCIPALNAME() will return the UPN (User Principal Name). Depending on your settings, in Power BI Desktop, the result can be exactly the same as for the USERNAME() function (as in my case), or it can return the email address of the user that is signed in to Power BI Desktop.

data-science dax towards-data-science data-visualization power-bi

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Tableau vs Power BI: Comparing the Data Visualization Tools

In analytics, Tableau is the leading visualisation tool. Its rich analytical features and attention to data details are the reason behind its popularity. Power BI, on the other hand, is preferred by professionals who are more comfortable with...

Power Query tips for every Power BI Developer

Use these simple yet powerful techniques to speed-up your Power BI development. If someone asks you to define the Power Query, what should you say?

Explore your JIRA Data with Power BI

JIRA Software provides bug tracking, issue tracking, and project management capabilities for teams and organizations. The JIRA content pack for Power BI helps you quickly import JIRA data so you can get an instant dashboard to analyze workloads...

Managing your Data with Microsoft’s Power BI

In a world where the sheer amount of data is often overwhelming, the ability to interrogate and organise data to make meaningful business decisions is more important than ever. Microsoft have created Power BI to enable every day users to use the...

Push Card visuals to a new level in Power BI

Push Card visuals to a new level in Power BI. Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with a simple workaround