Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

GilbertQ

Quick Tip - Why Q&A (Natural Query Language) is Awesome

Asking Q&A Questions relating to dates or times

 

The one thing that I think a lot of people do not realize that Q&A is aware of dates and times.

 

And by that I mean that Q&A knows when you mean today, it is today’s current date.

 

It’s always easiest to show with an example.

 

Q&A - 1.png

 

As you can see above I have asked the question what is my total revenue for today. (Where today’s date is 08 November 2016)

 

The thing here to take note of is that I do not have anything in my model that defines what “Today” is. Q&A is smart enough to know that today’s date is 08 November 2016.

 

But the WOW factor is that when you pin the above Q&A question to your dashboard, it will always show the revenue for your current day or date. (NOTE: As long as you are scheduling a refresh of your data)

 

So what this means is that this particular dashboard tile will always show ”Today’s” data without having to go and do any actual filtering or altering of any existing reports. I personally think that for people on the go, they just want to have the ability to have a quick glance at how things are doing without having to interact or filter their dashboard tiles. And this gives them that capability!

 

And to make it even better, you could then add an Alert, so that when the value is too high or too low, you will automatically get an alert. This makes your dashboard give your dashboard better insights, but also makes it proactive, instead of being reactive.

 

Other related date or times that you can use

The other dates that I have used in the past are the following:

 

  • Today
  • Yesterday
  • This Week, Last Week
  • This Month, Last Month
  • This Year, Last Year

As well as time related features

 

  • Right now
  • Past Minute, Past (x) Minutes
  • Past Hour, Past (x) Hours

Modify your Q&A Question if it is not answering as expected

 

The other thing that I have found is that whilst Q&A is very good at getting it right, sometimes due to your data, it can be difficult, or not answer the question in the way that you require.

 

But the Microsoft Power BI Team has done some great work, and if you are not aware when asking a Q&A question, you do have the ability to actually change what it is inputting into the fields in the Visualizations.

 

Once again best to show with an example.

 

I was asking the question as shown below.

 

Q&A - 2.png

 

Now what I wanted to do, was to rather have the Industry as the Legend and Product on the Axis, and have it as a Treemap visual. (Yes I am aware that I might have been able to change the order around, but it is to illustrate the example)

 

Now if you look to the right hand side of the screen you will see the Visualizations, Filters & Fields, click on the arrows to expand the fields.

 

Q&A - 3.png

 

And once done that you now will see the following below.

 

Q&A - 4.png

 

And now you can manually change your fields, as well as your visualizations to how you want it to look.

 

As with my example I swopped around the Industry and Product, and then changed the Visualization to a Treemap

 

Q&A - 5.png

 

So once done my Q&A question now looked like the following below.

 

Q&A - 6.png

 

I then took this and pinned it to my dashboard.

 

As you can see in doing it this way, it makes it very easy to get the desired result.

Conclusion

As you can see there are multiple ways to use Q&A as well as to create that WOW factor, and really get people excited about using Power BI.

 

Finally if you want to view the Q&A tips blog post, please see the link below. It is well worth the read.

 

Tips for asking questions in Power BI Q&A

Comments

Hi All,

 

Can we change the colors of custom visual charts for example sunbrust chart??? please let me know

 

Regards

kamal

Hi @kammaru, you should be able to change the color as you would with any Visual by going into the properties or paintbush area, and then look under data colors.

Hi Guavaq,

 

I did not find any property for changing color of chart and also there is no data label property for showing data label.

so can anybody help me here, or can you suggest me any other hierarchy chart??

 

Kamal

 

 

Hi @kammaru, it is due to the Custom Visual not having those properties. If you change it to a Donut chart, you will then get the available options as shown above.

 

What hierarchy are you trying to represent with your visual?