Reply
Occasional Visitor
Posts: 1
Registered: ‎01-12-2018
Accepted Solution

How do I create PowerBI charts by typing a description of the chart

At this point in the PowerBI intro video they say "no need to learn a new language" and demonstrate how a visualisation and inputs are picked by typing a description.

Where do I find this functionality in PowerBI?


Accepted Solutions
Highlighted
Established Member
Posts: 179
Registered: ‎05-13-2016

Re: How do I create PowerBI charts by typing a description of the chart

That video is slightly misleading.

 

That functionality is called "Q & A".  Once your PBIX file has been published, your users can type in a description of what they're looking for, and Power BI will attempt to create the visual on the fly.  It's a very slick feature.

 

However, as an author you still have to BUILD the report first.  This will likely require having a basic understanding of the DAX language.  Microsoft has created a library of "Quick Measures" that will get you started, and there are plenty of great, free resources out there to learn the DAX language. 

Try Rob Collies site: www.PowerPivotPro.com  or

Matt Allington's site: https://exceleratorbi.com.au/exceleratorblog/

 

Whatever you do, please don't just add columns to a visual, and let Power BI build "implicit measures" (the old way of creating Pivot Tables).  This is NOT best practice, and really sells Power BI short of what it can do.

 

Finally, to make the Q & A experience seemless for your audience, considerable time must be spent on naming columns and measures, and coming up with proper synonyms so that it works effortlessly.  It works out of the box, but a best in class Q & A dashboard had a lot of TLC behind the scenes.

View solution in original post


All Replies
Highlighted
Established Member
Posts: 179
Registered: ‎05-13-2016

Re: How do I create PowerBI charts by typing a description of the chart

That video is slightly misleading.

 

That functionality is called "Q & A".  Once your PBIX file has been published, your users can type in a description of what they're looking for, and Power BI will attempt to create the visual on the fly.  It's a very slick feature.

 

However, as an author you still have to BUILD the report first.  This will likely require having a basic understanding of the DAX language.  Microsoft has created a library of "Quick Measures" that will get you started, and there are plenty of great, free resources out there to learn the DAX language. 

Try Rob Collies site: www.PowerPivotPro.com  or

Matt Allington's site: https://exceleratorbi.com.au/exceleratorblog/

 

Whatever you do, please don't just add columns to a visual, and let Power BI build "implicit measures" (the old way of creating Pivot Tables).  This is NOT best practice, and really sells Power BI short of what it can do.

 

Finally, to make the Q & A experience seemless for your audience, considerable time must be spent on naming columns and measures, and coming up with proper synonyms so that it works effortlessly.  It works out of the box, but a best in class Q & A dashboard had a lot of TLC behind the scenes.