Q&A Visual – Define an Adjective for a Column

In the last post, I have explained how to work with Q&A visual .

There is a way to define terms for the Q&N visual.

There are two main terms

Adjective

Define an explanation for a column using a Measure. We able to define a measure as adjective for each columns of data.

Columns

Define a new name for a column such as Branch for the region and country.

In this example, I use the same datasets for the previous post as Customer feedback.

I am going to ask a question as

show me the great customer

As you can see in the above picture, the Great is not defined in the dataset, it has been shown in red color. That means it does not define before it. so we need to provide a definition for the Great.

Before that, you need to define a measure that can explain the great adjective. The adjective is about the average of ticket counts a customer issued.

Average ticket Count = AVERAGE(‘Customer Feedback'[TicketCount])

Click on the setting to navigate to the Q&A visual setting.

Then click on the Teach Q&A, then click on submit to define the great value.

Great mean the customer who has less ticket count on average than two, as you can see in the above picture.

The save it.

In the above picture, you can see the great is not anymore red, it is in blue color. and some of the customer ID is not on the list. That means it is already defined.

In the next post, I will explain how to define terms as synonyms, and how to manage it in the Q&A setting.

Leila Etaati on LinkedinLeila Etaati on TwitterLeila Etaati on Youtube
Leila Etaati
Trainer, Consultant, Mentor
Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

Leave a Reply