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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
andrew_abalobi
New Member

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.