Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
_DraftNote
_DraftNote

...

Expand
titleUsing the Ask a Question Feature


Power BI has an Ask a Question Feature that allows you to ask a question of the report data using your own words. The feature lets you explore your data using multiple presentations.

Tip
titleHelpful Hints

The results are interactive as you type the question.

You can add elements to an existing question, e.g., you can add "by gender" at the end of the question "Count of student UID , campus = USF Tampa, Card = Attend Orientation, Card Status = No" and the display updates automatically.

You can select an existing question and modify the options; the Q&A displays suggestions as you type.

You can choose different ways to display the data. Some of the typical ways to display are "as table," "as matrix" or "as bar chart."

Refer to Power Bi Tips and tricks for help in phrasing your own questions: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-q-and-a-tips


Here are some examples of questions you can ask:

  1. Show me Completion percentage by card and cohort sort and gender and ethnicity
  2. Show me count of student UID , campus = USF Tampa , card = Attend Orientation , card status = No , cohort sort = 201908 - Fall 2019 by college
  3. Show me count of student UID , campus = USF Tampa , card = Attend Orientation , card status = Yes , cohort sort = 201908 - Fall 2019 sort by student UID
  4. Completion percentage by card and gender and ethnicity for cohort sort = 201908 - Fall 2019
  5. Count of Student uids by year(start date),month(start date) for cohort sort = fall 2019 as table
  6. Show me card, not_completed #, cohort sort = 201908 - Fall 2019 , sort by Not_Completed # as table
  7. Showmecountofstudent UID,campus=USF Tampa,cohort sort=201908 - Fall 2019bycollegeascolumn chart
  8. Show me student UID for who has card status = Yes for card description = Submit Health Documents and start date > 10/31/19 and end date < 11/05/19 sort by student UID

  9. Completed # for card description = Submit Health Documents and start date > 10/31/19 and end date < 11/05/19


...