How to Enable DAX Suggestion in Power BI Desktop
Published May 23 2023 12:00 AM 8,162 Views
Microsoft

End to End Power BI Project with DAX Suggestion (3).png

 

 

DAX Suggestions Makes Power BI More Interesting

Let's start from here, the DAX Suggestion feature makes learning Power BI easier and more fun because it simplifies the process of creating measures, reduces the need for memorizing DAX syntax and functions, and helps you discover new possibilities for data analysis with Power BI.

 

 

dataset.png

 

A Short Survey: Kindly take few seconds to fill this survey about Power BI DAX

 

Welcome Back

This article will guide you on how to activate the DAX Suggestion Feature in Power BI Desktop. Let's have a look at the feature briefly by analyzing the magic happening in the image below.

 

1. Write what you want to achieve in natural language and the AI automatically generate the DAX function to achieve it

2. If you notice, I intentionally misspelt "Total" by writing "Toal" yet, it understood what I am trying to do.

 

 

DAXSugg.gif

 

 

How Do I Activate this Feature?

Given that you already have Power BI Desktop installed on your Windows PC, when you load data, you will see the illustration below.

 

Step 1: Login to Power BI Desktop

 

Power BI without DAX Suggestion Enabled Signed out.gif

 

This mean, you need to 

1. Login to your Power BI Account (Work/School Account is required here). You can also set up a M365 Developer Account and use the username created in the process to login.

2. You need to turn the QnA feature in your Power BI Desktop and in the Power BI Service Admin page.

 

Note: You must be an Admin or have Admin right to enable the Quick Measure suggestion in Power BI Service Admin page. If you have a M365 Developer Account, you have the admin right but if you are using your school or work account, you will need the admin to enable this feature

 

Once Logged in, when you click on the Quick Measure menu option, you will see a dialog window like in the image below

 

DAX Suggestion Guide 2 Login.gif

 

Step 2: Enable Quick Measure Suggestion Preview Feature on Power BI Desktop

Follow the guide below to enable Quick Measure Suggestion Preview Feature on Power BI Desktop

 

DAX Suggestion Enable Feature on PB Desktop.gif

 

Once enabled, you will need to save your file and restart your Power BI Desktop for it to take effect.

 

After restarting Power BI Desktop and clicking on the Quick Measure menu item, you will see a screen like what we have below

 

DAX Suggestion Admin Disable QnA.gif

 

Notification message: Either your admin disabled Q&A (which is required for this feature to work) or you're using a Live connected model (which isn't supported yet).

 

If the Suggestion feature is not enabled, this simply means you need to enable some features from the Power BI portal. 

Note: To make these changes, you need to have Admin right. If you are using Microsoft 365 Developer Account, you have admin rights with your primary account.

 

Step 3: Enable the Quick measure Suggestion on Power BI Admin Portal

Follow the guide below to get this done

 

DAX Suggestion Enable from Power BI Admin Portal.gif

 

Restart your Power BI Desktop to allow this change to take effect. 

Note: This entire process requires Internet Connectivity as this is the only way to synchronize the changes made online to the connected desktop account.

 

 

Step 4: Enjoy the DAX Suggestion feature

 

DAX Suggestion Final Result in Power BI.gif

 

 

Build an End-to-End Power BI Project Using the DAX Suggestion Feature

 

 

 

Take up this Data Analysis Project Challenge

Click Here: https://aka.ms/DAProductionOptimization 

 

 

 

 

Co-Authors
Version history
Last update:
‎May 23 2023 01:10 AM
Updated by: