Forum Discussion
Chart colors template
When creating charts in PowerPoint, there is an option to save a template when I have assigned colors to the various categories, which I can then reuse on subsequent by selecting that template. Does this feature exist in PowerBI, and if so, how to engage it?
Additionally, Excel/PPT preserve the order the answers are given but PowerBI does not appear to do this. Any thoughts on if/how it is possible to force the results to follow the same order? Ex: Strongly Disagree, Disagree, Neutral, Agree, Strongly Agree
Finally, has any progress been made on integrating Survey Monkey into PBI?
3 Replies
DistinctiveJay , first question yes, theme
https://docs.microsoft.com/en-us/power-bi/desktop-report-themes
The second one is the sort column, You can define order and mark that as sort column
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-cThanks for the tip on Themes. However, on the sort, I can't make this work. When I look on the Data tab, the information is still sorted in its original format. Why can't PowerBI simply match the order from the Data table? Surely that should be a simple option that seems to have escaped MS programmers. Also, I can't select the Sort By Column from the menu bar for some reason.
Hi DistinctiveJay ,
Can you provide assign colors to the various categories, and save more information of this template in powerbi, such as screenshots of expected results, etc.
In addition, the best way to perform an in-depth analysis of SurveyMonkey data with Power BI is to load SurveyMonkey data to a database or cloud data warehouse, and then connect Power BI to this database and analyze data. Skyvia can easily load SurveyMonkey data (including Contacts, Surveys, etc.) to a database or a cloud data warehouse of your choice.
For more details, you can read related document:
Cloud ETL Tool for SaaS, Databases & CSV - Skyvia
Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
