Forum Discussion
Need help on visualisation
Hi
Below Table 1 needs to be loaded into power BI. It is about dealers and its targets and actuals for current and previous quarter. Kindly show me step by step process on how to DAX or Model them and which chart would be appropriate.
| Dealer Performance Concern Process | New Vehicle Sales Target | Dealer Peer Comparator New Vehicle Sales | OVERALL NEW VEHICLE SALES QUALIFIER | Sales Experience Index Level 1 National Average Target | Sales Experience Index 12MR | OVERALL SALES Experience QUALIFIER | SERVICE Experience Index Level 1 National Average Target | SERVICE Experience Index 12MR | OVERALL SERVICE Experience QUALIFIER | Parts Sales Target | Dealer Peer Comparator Parts Sales | OVERALL PARTS SALES QUALIFIER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Q1 2025 | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | National 12MR Avg | Qualifier 12MR National Avg | PEER GROUP 12 MR AVG | Qualifier 12MR Regional Avg | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | National 12MR Avg | Qualifier 12MR National Avg | PEER GROUP 12 MR AVG | Qualifier 12MR Regional Avg | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | Dealer | Location | Presidents Award Groups | ZM | PMA | Actual | Target | % of Target | Actual | Target | % of Target | Actual | Target | % of Target | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | Survey Returns | Dealer NPS | Target Sales NPS | % | Survey Returns | Dealer NPS | Target Sales NPS | % | Survey Returns | Dealer NPS | National Avg | % of National Avg | PEER AVG | % of Regional Avg | Survey Returns | Dealer NPS | Target SERVICE NPS | % | Survey Returns | Dealer NPS | Target SERVICE NPS | % | Survey Returns | Dealer NPS | National Avg | % of National Avg | PEER AVG | % of Regional Avg | Actual | Target | % of Target | Actual | Target | % of Target | Actual | Target | % of Target | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | |||||||||||||||||||||
| 12345 | QWERT | Hamilton | GROUP 1 | pending - recruiting | ABCDE | 330 | 354 | 94% | 288 | 209 | 138% | No | 1,279 | 1,313 | 98% | No | 96.08% | 98% | 196.13% | 71% | No | 110.73% | 89% | No | No | 23 | 91.30 | 77.30 | 119% | 12 | 75.00 | 77.30 | 98% | No | 82 | 84.15 | 78.16 | 107.7% | No | 77.93 | 108% | No | No | 60 | 43.33 | 54.50 | 80% | 120 | 53.33 | 54.50 | 98% | Yes | 347 | 52.16 | 78.16 | 66.7% | Yes | 47.31 | 111% | No | No | 17,99,671 | 19,84,508 | 91% | 20,06,745 | 10,32,617 | 195% | No | 73,02,629 | 65,74,004 | 112% | No | 1 | 121% | 2 | 301% | No | 1 | 123% | No | No | |||
| 56789 | YUIOP | Auckland | GROUP 1 | Natalie | FGHIJ | 333 | 360 | 93% | 343 | 184 | 187% | No | 1,281 | 1,160 | 111% | No | 96.08% | 97% | 196.13% | 96% | No | 110.73% | 101% | No | No | 20 | 75.00 | 77.30 | 98% | 15 | 86.67 | 77.30 | 113% | No | 98 | 78.57 | 78.16 | 100.5% | No | 77.93 | 101% | No | No | 69 | 52.17 | 54.50 | 96% | 83 | 40.96 | 54.50 | 76% | Yes | 261 | 45.59 | 78.16 | 58.3% | Yes | 47.31 | 97% | Yes | Yes | 19,56,651 | 18,92,909 | 104% | 21,73,661 | 12,83,834 | 170% | No | 79,32,121 | 71,52,661 | 111% | No | 1 | 222% | 2 | 260% | No | 1 | 234% | No | No |
Table 1:
Hi Singh_Yoshi ,
You can follow the steps mentioned in the link to upload your data so that we can help you with your problem.
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216.
Please state your problem clearly as to where exactly you need help with and also provide expected output in the form of table or a screenshot so that we can get a clarity on what you are trying to achieve.
Thank you for your cooperation.
9 Replies
are all these data in one tabble? why it looks like contains two rows of headers and some column headers are missing. could you pls check if the data format is correct?
ryan_mayu I am not able to paste the table in this space as exactly as it looks in excel. After I pasted the table the format got changed automatically and shows some html error. I am not able to import the excel file also as it says .xlsx is not supported. Please help me on importing the file here
You may post a screenshot or a link to an Excel file stored in the cloud. Ensure that it is publicly accessible.
please share your email id and i will share the sample file and expected output.
Hi Singh_Yoshi ,
You can follow the steps mentioned in the link to upload your data so that we can help you with your problem.
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216.
Please state your problem clearly as to where exactly you need help with and also provide expected output in the form of table or a screenshot so that we can get a clarity on what you are trying to achieve.
Thank you for your cooperation.Singh_Yoshi Hey,
I will recommend that you need to create a excel file in your one drive and load in your power bi desktop using web connector or sharepoint folder connector.once this is done you can load the same file in power bi desktop. or create multiple seperate measure n that will fulfill your requirement.
Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your queryHi Singh_Yoshi ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank YouHi @Singh_Yoshi ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank YouHi @Singh_Yoshi ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You
