Issue with Q&A visual

Hi PoojaReddy ,

In looking at this I found this mention "Interact with the Q&A Explorer window as you would with the Q&A window on a dashboard or in a report. Visuals created using the Q&A button are for exploration only; they can't be saved to the report or dashboard. And, the Q&A button is only available in Reading mode"

That is from this article - Use Power BI Q&A to explore and create visuals in your reports - Power BI | Microsoft Learn

Do you think that is applicable to your situation?

Hi, PoojaReddy 

Your solution is great, collinq  It worked like a charm! Here I have another idea in mind, and I would like to share it for reference. 

First, you need to enable Q&A in Power BI Service, as shown in the following figure:

Here are some limitations of Q&A under Live connection:

You can click on the link below to learn how to configure Q&A under Live connection:

Use Q&A with live connections in Power BI - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.