Need help on visualisation

[Singh_Yoshi]

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:

[v-sdhruv]

Hi @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

[v-sdhruv]

Hi @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

[v-sdhruv]

Hi @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

[HarishKM]

@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 query

[v-sdhruv · Accepted solution]

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-...
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]

please share your email id and i will share the sample file and expected output.

[ryan_mayu]

@Singh_Yoshi 

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?

[Singh_Yoshi]

@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

[danextian]

You may post a screenshot or a link to an Excel file stored in the cloud. Ensure that it is publicly accessible.