Versions Compared

Old Version 103

changes.mady.by.user Lise Venning

Saved on

compared with

New Version 104

changes.mady.by.user Lise Venning

Saved on

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 and typically displays suggestions as you type the question.

Any filters you have selected in the report are applied to the results, e.g., if you have filtered for the College of Engineering, only Engineering students display in the results.

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 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 (try to copy/paste these into the field) :

  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


...

  1. Hover over the table, then click the ellipses in the top right corner of the table (note that you may have to click in the table first to be able to click on the ellipses option for the table).
  2. Select Export data.
  3. Click the Export button in the Export data dialog box.
    Click Open in the dialog box to work with the spreadsheet.
    Note: Depending on your browser and your settings, your system you may be prompted to open the spreadsheet automatically file, or you may show the downloaded file see a link to the exported file (such as data.xlsx) at the bottom left of your display. 

...