Creating Visuals with Q&A

You are currently viewing 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?

Here are some More Checkouts for Power BI Training in Australia

Power BI Training in Sydney
Power BI Training in Melbourne
Power BI Training in Brisbane
Power BI Training in Adelaide


This Post Has 74 Comments

  1. Bennett Laney

    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

    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

    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

    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

    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

    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

    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

    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

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

  9. Layla

    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. Keeley Bustillos

    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

    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

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

  13. Eliana

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

  14. Leighton

    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

    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

    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

    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

    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. Skincell Canada

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

  20. Anonymous

    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. Claude Albertson

    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

    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

    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

    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. Vivian Steiner

    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.

  26. Luci Wosher

    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.

  27. Zane Fikes

    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?

  28. Myrtis Nemeth

    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.

  29. Arletha Cardus

    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?

  30. Homer Sceusa

    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.

  31. Anonymous

    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!

  32. Shelley Morton

    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!

  33. Stanton Bent

    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.

  34. Gilda Fikes

    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!

  35. Lieselotte Fish

    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!

  36. Leonie Bigwood

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

  37. Karleen Griepentrog

    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!

  38. Duane Schumacher

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

  39. Shona Frias

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

  40. Quentin Yarnold

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

  41. Nickolas Eden

    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.

  42. roofing toronto

    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!

  43. Alan Penrod

    Touche. Outstanding arguments. Keep up the great effort.

  44. Ahmed Loar

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

  45. Blouse

    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!

  46. Hermelinda Ethridge

    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!

  47. Eden Gagnon

    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!

  48. Toni Renner

    Outstanding story there. What occurred after? Good luck!

  49. Jacki Fiorini

    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.

  50. Medin

    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.

  51. Kofron

    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.

  52. Robby Pantoja

    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!

  53. Gisele Apel

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

  54. Hudson Lassetter

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

  55. Silas Hilling

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

  56. Candice Barrows

    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!

  57. Shavonne Gladden

    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

  58. Russell Kolen

    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!

  59. Walker Reglin

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

  60. Ashton Dowd

    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

  61. Alexis Bunny

    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.

  62. Landon

    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!

  63. Erin Stinnett

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

  64. Esmeralda Mixon

    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.

  65. Eloise Rooke

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

  66. Bruce Spielbauer

    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!

  67. Katherin Ogilvie

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

  68. Crystle Walck

    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.

  69. Larue Edkins

    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!

  70. Eleanor Regalado

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

  71. Owen Emmett

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

  72. Natisha Serrato

    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