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.
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:
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.
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...
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?
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...
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. Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with a simple workaround