Forum Discussion
Need Help - Recreating Terminated Employee's Report
My director recently terminated my manager's position and I have been stepping in to take care of his responsibilites - one of which is a Power BI report and dashboard for survey response statistics by Account Management team. I am taking the tutorials and have figured out how to get the data into a table and create a pie chart. Need assistance with the following:
1. On pie chart, adding the count of completed, no response, and in progress survey statuses in 10s instead of 1000s.
2. Data card with response rate as percentage
3. Table with Account Manager name listed in label - label filters bottom table to Account Manager.
Any help would be appreciated.
2 Replies
Going to need some sample source data or a little more to go on, not sure what state you are in with building your report. Easiest thing to do would be to go into the O365 account, reset the user's password, logon and download or otherwise grab the report or find the original Power BI Desktop file.
Hi CMort,
1. On pie chart, adding the count of completed, no response, and in progress survey statuses in 10s instead of 1000s.
I'm not really clear about what you want. Maybe you can check Detail Labels option.
2. Data card with response rate as percentage
To format a number as percentage, we can try below:
3. Table with Account Manager name listed in label - label filters bottom table to Account Manager.
It seems that the "table" can be used for filter other visuals. If that is a case, it should be ChicletSlicer.
Best Regards,
Qiuyun Yu
