Need help on modelling and Visualization

[Singh_Yoshi]

Hi Below is the Source file format

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	########	2	########	No	1	########	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	########	2	########	No	1	########	No	No

@ibendlin @rajendraongole1 @Dinesh_Y

[v-sathmakuri]

Hi @Singh_Yoshi ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-sathmakuri]

Hi @Singh_Yoshi ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

If the issue remains unresolved, kindly share sample data and clearly outline the expected results.

Thank you!!

[v-sathmakuri]

Hi @Singh_Yoshi ,

Thank you for reaching out to Microsoft Fabric Community.

Could you please provide more details about your question so we can assist you more effectively?

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 & Regards,

Rekha,

CustomerSupportTeam.

[Singh_Yoshi]

I have a source file that contains data of dealers and its actuals and targets for Q4 and Q1. I want to bring that data into dashboard. I have also a format of how the dashboard look like. But I'm not able to attached excel file as I dont see that option in my interface fabric community. So I used table option to paste my data(both source file as well as dashboard format)
If you refer my previous texts you will have a data and if you can copy and paste it in excel, you may get some idea.

@v-sathmakuri 

[v-sathmakuri · Accepted solution]

Hi @Singh_Yoshi ,

If you need help uploading data you can use the below link for the process.

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-provide-sample-data-in-the-... 

Other process to share the file: please save the sample and expected data in an Excel file, upload it to SharePoint, and share the link with me.

Thank you!!

[Singh_Yoshi]

Below is the requirement using the source file I already posted,

	Dealer Performance Concern Process
	Please refer to DCB 091.23 - REISSUE dated 10th Feb 2025 for more information.
			Dealer Code		#REF!
			Dealer Name		#N/A
			Location		#N/A
			PMA		#N/A
			Presidents Awards Group		#N/A
New Vehicle Sales		Sales One Cx  Performance
Sales Target		Level 1 National Sales Experience Index Target
	Actual	Target	% of Target			Survey Returns	Dealer NPS	Target Sales NPS	% of Target
#REF!	#N/A	#N/A	#N/A		#REF!	#N/A	#N/A	#N/A	#N/A
#REF!	#N/A	#N/A	#N/A		#REF!	#N/A	#N/A	#N/A	#N/A
Qualifier 2 previous quarters	#N/A		Qualifier 2 previous quarters	#N/A
	Actual	Target	% of Target		National Average
12MR	#N/A	#N/A	#N/A			Survey Returns	Dealer NPS	Target Sales NPS	% of Target
Qualifier 12MR	#N/A		12MR	#N/A	#N/A	#N/A	#N/A
					Qualifier 12MR	#N/A
Peer Comparator
	Actual	Target	% of Target		PEER COMPARATOR
#REF!	-	#N/A	#N/A			Survey Returns	Dealer NPS	PEER AVG	% of Target
#REF!	-	#N/A	#N/A		12MR	#N/A	#N/A	#N/A	#N/A
Qualifier 2 previous quarters	#N/A		Qualifier 12MR	#N/A
	Actual	Target	% of Target
12MR	-	#N/A	#N/A
Qualifier 12MR	#N/A
Overall New Vehicle Sales Qualifier	#N/A		OVERALL SALES CVP QUALIFIER	#N/A

[Singh_Yoshi]

@v-dineshya  @rajendraongole1 @lbendlin 

[Singh_Yoshi]

@Dinesh_Y  @rajendraongole1 @lbendlin