Power BI

Creating Visuals with Q&A

With the world, growing advanced and apparently swifter by every passing second, the struggle to get the required information in the shortest and quickest possible time is becoming equally intense. It is because of the fact that the concept of multi-tasking has evolved enough that people prefer to have everything within the reach of their hand.

To put it bluntly, everyone likes to get exactly what he or she asks for with least amount of effort. The most renowned search engine, such as Google, catered to this need of people in an exquisite manner. If not all, majority of people resort to google to search for almost anything.

Now imagine ‘telling’ a software solution what you want from it. Yes, you heard it right! A solution that is powerful enough to provide you with exact information you need. If you are still confused about the existence of such a solution, then let us unfold the curtains and tell you that it is about time you get to know this compelling software solution better known as Power BI.

So let us dig into one of the most attractive features that power BI delivers its users with: The Visuals. Visuals are the need of every business, big or small, new or old. They are an easy to understand representation of data that looks equally appealing and much more organized.

Yet, what sort of visuals to use and where to find such visuals? These tasks might seem daunting but not anymore. With the help of Power BI, you can build visuals by just asking questions in your natural language and let the software do the rest for you.

Power BI is very well equipped with Artificial Intelligence that enables it to construct a visual that can answer your question/s.

Although Microsoft Power BI provides incredible options to create reports and dashboards, there are still some questions that a dashboard will not be answering. This is true especially true when a non-technical business executive uses the dashboard with different requirements.  

Now what if the user can ask questions related to the data in their own language? 

This blog post walks through the amazing Q&A feature of Power BI.

Lets try this by asking our first question. For this you need to log on in your Power BI service.  Click Sales Dashboard inside Power BI Service.

Here comes our first question, What is the the total profit.  Click Q&A field on the upper-left corner of the Dashboard and start by typing “P”


Notice that it starts suggesting fields and items starting with the letter “P. This feature is called intellisense. This feature used the Power BI’s built in recommendation engine to offer you with the options that you might be interested in. 

Now we need to enter our choice into the system. For this type Profit and hit Enter

Here you go!

You will get total profit figure as a result visualized in a Card
Congratulations! You just asked a question and got correct answer from Q&A.

Lets try some other examples to make use of this powerful feature. 

Use of aggregation in Q&A

Creating Pie Chart with Q&A

Creating bar graph with Q&A

Type “profit before July by retailer type by order method type as column sort by profit” in the Q&A field.

Creating Area chart with Q&A

In the question box type “month year 2016 revenue and month year 2017 as area chart” in the Q&A Selection

Now click on on the suggestions.

An area chart showing the trend of revenue over the span of two years is created.
Click on the Pin visual icon at the top.
pin visual
Select the dashboard. Click OK. Your visual is pinned to the dashboard. 

If you found this interesting and want to Learn Power BI from Scratch or its advanced features, get a complete, in-depth introduction to Microsoft Power BI tool by attending our Power BI Basic Training Course. There are countless features waiting for you to explore them. So, what is stopping you from exploring your full potential?

Back to list

74 thoughts on “Creating Visuals with Q&A

  1. you’re truly a excellent webmaster. The web site loading speed is amazing. It seems that you’re doing any unique trick. Also, The contents are masterwork. you have performed a magnificent process on this topic!

  2. Evan says:

    Hi to every one, it’s really a pleasant for me to pay a quick visit
    this web page, it contains important Information.

  3. Kailyn says:

    Spot on with this write-up, I truly think this amazing site needs a great deal more attention. I’ll
    probably be back again to read through more, thanks for the advice!

  4. msg10521 says:

    Great web site you’ve got here.. It’s hard to find good quality writing like yours these days.
    I truly appreciate people like you! Take care!!

  5. Natalie says:

    I know this web site gives quality depending articles or
    reviews and additional information, is there any other site which gives these kinds of things in quality?

  6. Gabriel says:

    Hello! This is my 1st comment here so I just wanted to give a
    quick shout out and tell you I genuinely enjoy reading through your articles.
    Can you recommend any other blogs/websites/forums that cover the same topics?
    Thank you!

  7. Keto says:

    Sweet blog! I found it while surfing around on Yahoo
    News. Do you have any tips on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get
    there! Thank you

  8. Victor says:

    I think that what you published was actually very logical.
    However, what about this? what if you typed a catchier post title?
    I mean, I don’t wish to tell you how to run your blog, but suppose you added a headline
    to possibly get a person’s attention? I mean Creating
    Visuals with Q&A | Power BI Training Australia is kinda plain. You could look at Yahoo’s home page and see how they
    create post titles to grab viewers to click. You might try adding a video or a pic or two to get readers excited about what you’ve got to say.
    In my opinion, it might make your posts a little livelier.

    1. AMZ Consulting says:

      Thankyou for your recommendations, we’ll surely work on this in our future posts.

  9. Layla says:

    I am really loving the theme/design of your web site. Do you ever run into
    any internet browser compatibility issues? A small number of my blog visitors have complained about my blog not operating correctly
    in Explorer but looks great in Firefox. Do you have any recommendations to help fix this problem?

  10. I’m not that much of a online reader to be honest but your sites really nice, keep it up! I’ll go ahead and bookmark your website to come back later on. Many thanks

  11. Maison says:

    I’ve been exploring for a little bit for any high-quality articles or weblog posts in this kind of space .
    Exploring in Yahoo I eventually stumbled upon this website.
    Reading this info So i am satisfied to express that I’ve an incredibly just right uncanny feeling I came
    upon just what I needed. I so much certainly will make certain to don?t fail to remember this site and give it a look regularly.

  12. Athena says:

    Why users still use to read news papers when in this technological world everything is presented on net?

  13. Eliana says:

    Post writing is also a excitement, if you know then you can write
    if not it is complex to write.

  14. Leighton says:

    Good day! I know this is somewhat off topic but I was wondering if you knew where I
    could find a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having trouble finding one?
    Thanks a lot!

  15. Jacob says:

    Having read this I thought it was extremely enlightening.
    I appreciate you finding the time and energy to put this information together.
    I once again find myself personally spending a lot of time both reading and commenting.
    But so what, it was still worthwhile!

  16. Paisley says:

    Hi there everyone, it’s my first go to see at this website, and
    post is genuinely fruitful designed for me, keep up posting these types of articles.

  17. Ethan says:

    Hello to all, the contents existing at this website are truly amazing for people knowledge, well, keep up the good work fellows.

  18. click here says:

    I think this is one of the most significant
    information for me. And i am glad reading your
    article. But wanna remark on some general things,
    The site style is perfect, the articles is really nice : D.
    Good job, cheers

  19. Hi, everything is going perfectly here and ofcourse every one is sharing data,
    that’s actually good, keep up writing.

  20. Anonymous says:

    I like the helpful information you provide in your articles.

    I’ll bookmark your blog and check once more right here regularly.
    I’m relatively sure I will be informed many new stuff right here!
    Good luck for the following!

  21. If you would like to improve your familiarity simply keep visiting this site and be updated with the most up-to-date news posted here.

  22. Makenzie says:

    I’m not that much of a internet reader to be honest but your sites really nice, keep it up!
    I’ll go ahead and bookmark your site to come back later
    on. All the best

  23. Remy says:

    After looking into a number of the blog articles on your blog, I seriously
    appreciate your way of blogging. I added it to my bookmark webpage list and will be checking back in the near future.
    Please check out my web site too and tell me what you think.

  24. Andrew says:

    Just wish to say your article is as surprising. The clearness in your post is simply spectacular
    and i can assume you’re an expert on this subject.
    Fine with your permission allow me to grab your RSS feed to keep up to date with forthcoming
    post. Thanks a million and please keep up the enjoyable work.

  25. Like!! Thank you for publishing this awesome article.

  26. Hi there, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam feedback? If so how do you protect against it, any plugin or anything you can recommend? I get so much lately it’s driving me mad so any help is very much appreciated.

  27. Luci Wosher says:

    I simply want to mention I’m very new to blogs and seriously loved your web site. Most likely I’m planning to bookmark your site . You amazingly come with fantastic posts. Appreciate it for revealing your website page.

  28. Zane Fikes says:

    I know this web page gives quality dependent articles or reviews and extra material, is there any other site which provides these kinds of data in quality?

  29. Great post. I used to be checking constantly this weblog and I’m inspired! Extremely useful info particularly the closing part 🙂 I take care of such info much. I was looking for this particular info for a very lengthy time. Thank you and good luck.

  30. I’m really loving the theme/design of your blog. Do you ever run into any internet browser compatibility problems? A number of my blog readers have complained about my blog not operating correctly in Explorer but looks great in Chrome. Do you have any suggestions to help fix this issue?

  31. Homer Sceusa says:

    I always emailed this web site post page to all my contacts, for the reason that if like to read it after that my links will too.

  32. Anonymous says:

    This is the right blog site for anyone who intends to discover this subject. You understand so much its virtually hard to argue with you (not that I really would want?HaHa). You most definitely put a brand-new spin on a subject thats been covered for several years. Great things, simply wonderful!

  33. Greetings! I know this is kinda off topic but I’d figured I’d ask. Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa? My website addresses a lot of the same topics as yours and I believe we could greatly benefit from each other. If you happen to be interested feel free to shoot me an e-mail. I look forward to hearing from you! Fantastic blog by the way!

  34. Stanton Bent says:

    I’ve been browsing online more than three hours nowadays, but I never found any attention-grabbing article like yours. It is pretty worth sufficient for me. In my opinion, if all web owners and bloggers made good content material as you did, the net might be a lot more helpful than ever before.

  35. Gilda Fikes says:

    Thanks for the marvelous posting! I actually enjoyed reading it, you may be a great author. I will always bookmark your blog and may come back in the future. I want to encourage one to continue your great job, have a nice evening!

  36. You actually make it seem so easy with your presentation but I find this topic to be really something that I think I would never understand. It seems too complex and very broad for me. I’m looking forward for your next post, I will try to get the hang of it!

  37. Hi there Dear, are you truly visiting this site daily, if so after that you will absolutely get nice knowledge.

  38. Wow, awesome blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your web site is great, let alone the content!

  39. Quality content is the key to invite the visitors to visit the web site, that’s what this web page is providing.

  40. Shona Frias says:

    Very rapidly this web page will be famous amid all blog visitors, due to it’s fastidious content

  41. It is not my first time to visit this web page, i am visiting this website dailly and take fastidious data from here daily.

  42. May I simply just say what a comfort to uncover somebody that actually knows what they are discussing on the net. You actually understand how to bring a problem to light and make it important. More and more people should look at this and understand this side of the story. I was surprised you are not more popular given that you certainly possess the gift.

  43. Nice read, I just passed this onto a colleague who was doing a little research on that. And he actually bought me lunch because I found it for him smile Therefore let me rephrase that: Thank you for lunch!

  44. Alan Penrod says:

    Touche. Outstanding arguments. Keep up the great effort.

  45. Ahmed Loar says:

    This paragraph will help the internet viewers for building up new webpage or even a blog from start to end.

  46. Blouse says:

    Fantastic website. A lot of helpful info here. I’m sending it to some friends ans also sharing in delicious. And naturally, thank you in your sweat!

  47. You ought to be a part of a contest for one of the highest quality sites on the internet. I most certainly will recommend this website!

  48. Eden Gagnon says:

    My brother suggested I might like this blog. He was totally right. This post actually made my day. You cann’t imagine just how much time I had spent for this info! Thanks!

  49. Toni Renner says:

    Outstanding story there. What occurred after? Good luck!

  50. For most up-to-date information you have to go to see internet and on the web I found this web page as a finest web page for latest updates.

  51. Medin says:

    Hi my loved one! I want to say that this post is awesome, nice written and include almost all vital infos. I would like to peer extra posts like this.

  52. Kofron says:

    Thank you for the sensible critique. Me & my neighbor were just preparing to do some research about this. We got a grab a book from our local library but I think I learned more from this post. I’m very glad to see such great info being shared freely out there.

  53. I really love your blog.. Very nice colors & theme. Did you develop this amazing site yourself? Please reply back as I’m planning to create my own personal site and want to find out where you got this from or what the theme is named. Kudos!

  54. Gisele Apel says:

    Thanks for sharing your thoughts. I truly appreciate your efforts and I am waiting for your next write ups thank you once again.

  55. Hi, all is going perfectly here and ofcourse every one is sharing data, that’s really excellent, keep up writing.

  56. Hello I found your blog on google and loved reading it greatly. I’ve bookmarked your website and will be back.

  57. I like the helpful info you provide in your articles. I will bookmark your blog and test again here regularly. I am slightly sure I will learn many new stuff proper right here! Good luck for the next!

  58. That is very fascinating, You’re an overly professional blogger. I have joined your rss feed and look ahead to searching for extra of your great post. Additionally, I’ve shared your site in my social networks

  59. Many thanks for posting this, It?s simply what I used to be researching for on bing. I?d a lot comparatively hear opinions from an individual, slightly than a company web page, that?s why I like blogs so significantly. Many thanks!

  60. This website is my aspiration , very wonderful pattern and perfect articles .

  61. Ashton Dowd says:

    I love your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to construct my own blog and would like to know where u got this from. many thanks

  62. Alexis Bunny says:

    If some one wishes to be updated with latest technologies therefore he must be pay a visit this web page and be up to date daily.

  63. Landon says:

    Please let me know if you’re looking for a writer for your blog. You have some really great posts and I think I would be a good asset. If you ever want to take some of the load off, I’d really like to write some articles for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Thank you!

  64. This piece of writing is really a good one it helps new web people, who are wishing in favor of blogging.

  65. My relatives always say that I am killing my time here at net, except I know I am getting knowledge all the time by reading such fastidious articles.

  66. Eloise Rooke says:

    This piece of writing gives clear idea designed for the new visitors of blogging, that in fact how to do running a blog.

  67. Someone essentially assist to make seriously posts I might state. This is the very first time I frequented your web page and to this point? I amazed with the analysis you made to make this particular publish incredible. Excellent task!

  68. This is my first time pay a quick visit at here and i am actually happy to read all at one place.

  69. Hi there to every one, as I am truly eager of reading this weblog’s post to be updated daily. It consists of pleasant stuff.

  70. Larue Edkins says:

    I’m truly enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a developer to create your theme? Fantastic work!

  71. Very descriptive post, I enjoyed that bit. Will there be a part 2?

  72. Owen Emmett says:

    Hi, this weekend is good designed for me, as this point in time i am reading this wonderful informative article here at my residence.

  73. Howdy! I understand this is kind of off-topic but I had to ask. Does managing a well-established website such as yours take a massive amount work? I’m brand new to blogging however I do write in my journal every day. I’d like to start a blog so I can share my personal experience and feelings online. Please let me know if you have any kind of ideas or tips for brand new aspiring blog owners. Appreciate it!

Leave a Reply

Your email address will not be published. Required fields are marked *