Forum Discussion
Dashboard Visual keeps changing
- 1 year ago
Hi SamfarUK,
Thank you for reaching out to Microsoft Fabric Community.
When we use the "ask a question about your data" feature in Power BI to create a visual, the tool automatically selects the best visual type for example bar chart. While we can modify it for example to a pie chart. But the Q&A-generated visuals do not retain visualization changes when pinned to a dashboard. Instead they revert to their default type when pinned.
To ensure that the visual stays as a pie chart in the dashboard, follow below steps:
- Use the Q&A feature to generate the desired insight visual.
- Modify the visual to a pie chart using the visualization toolbar.
- Click on "Save as a Report" and after that open the saved report in power bi.
- Pin the pie chart from the report instead of directly from Q&A
- Now, the pinned visual will remain as a pie chart in the dashboard.
Since power bi does not retain visualization changes for Q&A-generated visuals when pinned, saving it as a report converts it into a standard visual, which allows power bi to persist changes. So, save the Q&A visual as a report first and then pin it from the report. This should solve your issue.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi SamfarUK,
Thank you for reaching out to Microsoft Fabric Community.
When we use the "ask a question about your data" feature in Power BI to create a visual, the tool automatically selects the best visual type for example bar chart. While we can modify it for example to a pie chart. But the Q&A-generated visuals do not retain visualization changes when pinned to a dashboard. Instead they revert to their default type when pinned.
To ensure that the visual stays as a pie chart in the dashboard, follow below steps:
- Use the Q&A feature to generate the desired insight visual.
- Modify the visual to a pie chart using the visualization toolbar.
- Click on "Save as a Report" and after that open the saved report in power bi.
- Pin the pie chart from the report instead of directly from Q&A
- Now, the pinned visual will remain as a pie chart in the dashboard.
Since power bi does not retain visualization changes for Q&A-generated visuals when pinned, saving it as a report converts it into a standard visual, which allows power bi to persist changes. So, save the Q&A visual as a report first and then pin it from the report. This should solve your issue.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
So it's not user error then, it is the way it dashboard functionality is built. Not very helpful in my opinion, especially when trying to get new users to PBI, they think it's frustrating enough to work with. Thank you for your response however. I will use the "question" to force it into the visual I require. Hopefully someone at Microsoft or PBI will see this!