New features in the November 2018 update of Power BI Desktop
Part five of an eight-part series of blogs

A big new update this month, including expandable row headings in matrices, copying and pasting between visuals and conditional formatting of charts (although it's what's waiting in preview which will really blow your mind).

  1. Changes introduced in the November 2018 Power BI update
  2. Expandable row headers in matrices
  3. Conditional colours now apply to charts too
  4. Copying and pasting visuals between Power BI reports
  5. Asking related questions in the Q and A Explorer (this blog)
  6. Composite models and many-to-many relationships
  7. Preview - relationship diagrams and new ways to filter
  8. Summary of features waiting in preview - November 2018

For a cumulative list of all of the updates to Power BI Desktop in the last few year or two, see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 26 November 2018

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Asking related questions in the Q and A Explorer

To explain this topic, let's start with what the Q&A Explorer is and does.  I'll then explain how you can use it to ask related questions!

Creating Q&A dialog boxes

In Power BI Desktop you can add a Q&A button:

Adding a Q&A button

Use this option on the Home tab of the Power BI ribbon to create a button for creating a Q&A dialog box.

 

You can then optionally format this button to contain text too, along with applying any other required formatting changes:

Q&A button format

To see more on how to get action buttons looking the way you want them to, see this blog page.

 

When you hold down the Ctrl key and click on the button, you'll see this:

Asking questions

You can ask questions, and save them in this page of your report.

You won't need to hold down the Ctrl key when you publish your report - just when you're viewing it in Power BI Desktop.

Asking related questions

Following the November Power BI update, you can now choose to ask a related question:

Related question button

Click on a saved question, then click on the Ask a related question button.

So what to ask?  The only examples I could come up with are to change the chart type:

Related question being asked

So here I've asked to view the chart as a tree diagram instead. Power BI changes the visual type, but I can still scroll down to see the original visual.

 

This features seems a bit disappointing at the moment, as it doesn't seem possible for your related question to add a filter to the original visual.

This blog has 0 threads Add post